sum across a number of sheets and ranges

[tintin1012000]

I have an a summary of products in worksheet (Products ) Column A:A and I want a formula to find whats in A1 (searching 3 other worksheets) and returning the total

the other worksheets are constructed like.
in worksheet 2 I have summary of products in Column A:A and a total in Column B:B.
I have summary of products in Column A:A and a total in Column B:B
I have summary of products in Column D:D and a total in Column E:E
I have summary of products in Column G:G and a total in Column H:H and so on

Thanks again

 

[mehidy1437]

hi generate the sheet name in SheetList tab & use this formula in the Products tab.

excel-sumif across multiple sheets in excel

excel-sumif accross multiple sheet in excel.xlsx
	A	B	C
1	TEE		300
2	PANT		600
3	JACKET		900
PRODUCTS

Cell Formulas
Range	Formula
C1:C3	C1	=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList!$A$3:$A$5&"'!A:A"),$A1,INDIRECT("'"&SheetList!$A$3:$A$5&"'!B:B")))