View Single Post
  #2   Report Post  
Chris Rogers
 
Posts: n/a
Default

You can do this a number of simple ways...

Each sheet can have your data in a standard format (say for regions -
each sheet would have that regions numbers in it) and have a summary
sheet that references all of the other sheets - if they are formated
the same, it is as simple as entering the = sign in the summary cell,
and then selecting the cell in each sheet you want to add into that
cell one at a time wile pressing the + key to add them up. You only
need to build this formula once, then you can copy and paste to the
other summary areas of your summary sheet.

hth
chris