Sum across a no. of worksheets

  • Thread starter Thread starter mdenning
  • Start date Start date
M

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
 
Back
Top