Sumifs

[KtomK]

hi

i would like to know the formula for to consolidate data from Sheet 1.
outcome should be as in sheet 2.

Sheet 1 A B C A B C 01.01.2019 1 1 1 1 02.01.2019 1 1 1 1 03.01.2019 1 1 1 Sheet 2 A B C 01.01.2019 2 2 0 02.01.2019 1 1 2 03.01.2019 1 1 1 <colgroup><col><col span="6"></colgroup><tbody> </tbody>

<tbody>
</tbody>

thx for your support

Best,
TKT

 

[AlanY]

try

Book1
	A	B	C	D	E	F	G
1		A	B	C	A	B	C
2	01.01.2019	1	1		1	1
3	02.01.2019	1		1		1	1
4	03.01.2019	1		1		1
5
6		A	B	C
7	01.01.2019	2	2	0
8	02.01.2019	1	1	2
9	03.01.2019	1	1	1
Sheet5

Cell Formulas
Range	Formula
B7	=SUMPRODUCT(($A$2:$A$4=$A7)*($B$1:$G$1=B$6),$B$2:$G$4)

 

[KtomK]

try

	A	B	C	D	E	F	G
1		A	B	C	A	B	C
2	01.01.2019	1	1		1	1
3	02.01.2019	1		1		1	1
4	03.01.2019	1		1		1
5
6		A	B	C
7	01.01.2019	2	2	0
8	02.01.2019	1	1	2
9	03.01.2019	1	1	1

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet5​

Worksheet Formulas Cell Formula B7 =SUMPRODUCT(($A$2:$A$4=$A7)*($B$1:$G$1=B$6),$B$2:$G$4) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thanks AlanY, this worked!

cheers

 

[AlanY]

You’re welcome