Need help pulling sums by month from data sheet

[ejerb]

Hello, and thank you for any help!

My existing data sheet columns are "DATE , PART# , GOOD PARTS , REWORK , SCRAP

I am trying to make a new sheet that can pull sums of GOOD PARTS, REWORK, SCRAP by month and part # from my data sheet.

So on my NEW excel file I would like to have multiple sheets representing every month, and have every one of those sheets list every part #.

SO on the new sheet - Next to the part #'s column I will have GOOD PARTS column, REWORK column, SCRAP column -

The question what formula(s) can I use to sum up these columns by month and specific to each part #.

ex. my new sheet for January will show "Part X" and the next 3 columns (Good parts, rework, scrap,) will sum up the Good, rework, and scrap for that month. (pulling data from another sheet)

Please help and thanks!! feel free to ask me to elaborate.

 

[Fluff]

Hi & welcome to MrExcel.
Maybe something like

Excel 2013/2016
	A	B	C	D	E
1	Date	Part #	Good	Rework	Scrap
2	01/01/2019	AL1 1HB	3	2	1
3	02/01/2019	AL1 1WB
4	03/01/2019	AL1 2NF	95	32
5	04/01/2019	AL1 1HB	19	9	10
6	05/01/2019	AL1 1WB	31	13
7	06/01/2019	AL1 2NF	7	4	15
8	07/01/2019	AL10 1DJ		3	7
9	01/03/2019	AL1 1HB	21	6
10	02/03/2019	AL1 1WB			5
11	03/03/2019	AL1 2NF	24	15	4
12	04/03/2019	AL3 5LE	41	29	3
13	01/04/2019	AL1 1HB	8	2
14	02/04/2019	AL1 1WB	8	6	20
15	03/04/2019	AL1 2NF	53	25	17
Data

Excel 2013/2016
	A	B	C	D
1	01/01/2019
2	Part #	Good	Rework	Scrap
3	AL1 1HB	22	11	11
4	AL1 1WB	31	13	0
5	AL1 2NF	102	36	15
6	AL10 1DJ	0	3	7
7	AL3 5LE	0	0	0
January

Cell Formulas
Range	Formula
B3	=SUMPRODUCT((Data!$B$2:$B$15=$A3)*(MONTH(Data!$A$2:$A$15)=MONTH($A$1)),Data!C$2:C$15)

 

[ejerb]

thank you @Fluff !!!! you are the man

 

[Fluff]

You're welcome & thanks for the feedback