Apply formula to rows and columns

[andresf]

Hi,

Can someone please help me with this?

I have a big data base that looks similar to this:

	A	B	C
1	PRODUCT	DATE	SALES
2	AB1	Jan-21	100
3	AB2	Feb-21	150
4	AB3	Mar-21	50
5	AB4	Apr-21	200
6	AB5	Jan-21	50
7	AB5	Feb-21	300
8	AB5	Jun-21	1000
9	AB5	Jun-21	1500
10	AB6	Jun-21	2000

How can I set up the $ in the Sumifs formula so I can apply efficiently the formula to rows and columns? Should I apply first to rows or columns?

	D	E	F	G	H	I	J
1		Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21
2	AB1	+SUMIFS($C$2:$C$10;$B$2:$B$10;E1;$A$2:$A$10;D2)
3	AB2
4	AB3
5	AB4
6	AB5

 

[etaf]

what does
=SUMIFS($C$2:$C$10;$B$2:$B$10;E1;$A$2:$A$10;D2)
give you ?

you should be able to copy that across and down OR down and across ,
IF you add some more $ to fix the criteria cells
SUMIFS($C$2:$C$10;$B$2:$B$10;E$1;$A$2:$A$10;$D2)
now you should copy across the columns and then down the rows
OR down the rows and across the columns
wont matter the $ are fixing the reference