Sumif from multiple worksheets

[Dewdrop]

Hi friend,

I would like to sum the products from multiple worksheets for a specific month. please refer to the file for details. What is the best way to do it?

Appreciate for your guidance and sharing

Thank you very much.

[FDibbins]

Try this...

	A	B	C	D
4	Wood	W_125	2296	2296
5	Wood	W251	890	890
6	Metal	M_046	2444	2444
7	Plastic	P_410	0	0
8	Plastic	P_110	1203	1203
9		Total	6833

D2=SUMPRODUCT(--(INDIRECT(B4&"!$C$1:$O$1")=$C$1)*(INDIRECT(B4&"!$C$2:$O$50")))
copied down.

NOTE - make your your sheet names in Summary column B match the actual sheet names (W251 did not)

[Dewdrop]

Hi FDibbins, it's what i looking for. Thanks for your guidance and sharing.

[FDibbins]

Dewdrop, it was my pleasure, and thank you for the feedback