Month Sum based and dates and a name

[CD2019QA]

I have a spreadsheet called "Scrap Detail" where we log what items we scrap and against what work cell.
Column A has the date and column B has a drop down to select the Cell. The value of the scrap is then totalled in Column F.
We then have different work cells within the business where I have to report how much scrap each cell has disposed of each month.
I then have a summary page called "Totals" with all the cells listed in rows (A4:A37) and the 12 months across the top in columns (B3:M3).
A new spreadsheet is created annually so I don't need to worry about years.
I was then hoping that the cells on the Totals page would auto populate and sum from info loaded from the scrap details tab.
I cannot find anything to solve this problem. See images attached also.
I would be so grateful for any help.

Thanks

 

[jmacleary]

Hi there. To do this I have added a helper column on your scrap details page (column G) which you can always hide so long as you make sure the formula is copied all the way down.

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
3	Cell	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
4	ATS	23.45	0	0	0	0	0	0	0	0	0	0	0	23.45
5	Barrels	0	0	0	0	0	11	0	0	0	0	0	0	11
6	CNC3	0	0	34.56	0	0	0	0	0	0	0	0	0	34.56
Scrap Totals

Cell Formulas
Range	Formula
B4:M6	B4	=SUMIFS('Scrap Detail'!$F:$F,'Scrap Detail'!$B:$B,'Scrap Totals'!$A4,'Scrap Detail'!$G:$G,COLUMN(B3)-1)
N4:N6	N4	=SUM(B4:M4)

Book1
	A	B	C	D	E	F	G
1	Date	Cell	qty	part	value	total
2	01/01/2019	ATS				23.45	1
3	12/03/2019	CNC3				34.56	3
4	15/06/2019	Barrels				11	6
Scrap Detail

Cell Formulas
Range	Formula
G2:G4	G2	=MONTH(A2)

 

[CD2019QA]

Thanks very much, this was most helpful.