sUM OF VALUES ACROSS A NO. OF WORKSHEETS

[mdenning]

I have 7 worksheets each corresponding to a country then I have a las
worksheet which is global. In each worksheet I have a list of product
and no's ordered. Each Worksheet has different products but a most o
them run across all worksheets. I am trying to put in a formula into m
global worksheet to add i.e all the shirts on order in all countries!

How would I do that?
Many thanks

Example of different worksheets

Products- UK
shirts 10
shorts 5
jerseys 7

Products- Australia
Shirt 12
Shorts 10
Jersey 2

Global
Shirts X
Shorts X
Jersey X

So in global I need a formula to work out sum of all shirts etc

 

[Domenic]

On your Global worksheet, enter the following formula in B1 and cop
down:

=SUMPRODUCT(SUMIF(INDIRECT("'"&$D$1:$D$2&"'!A1:A3"),A1,INDIRECT("'"&$D$1:$D$2&"'!B1:B3")))

...where D12 contain your list of worksheets. Of course, you ca
expand this list to include all 7 of your worksheets. Make sure yo
adjust the reference accordingly.

Also, for other ideas, have a look at the following website...

http://www.mcgimpsey.com/excel/threedsumif.html

Hope this helps!