how do i reference multiple rows/columns with one function?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to reference multiple columns/rows on one worksheet to summarize
in another. Can I do this with one function? Can I add a row or column on
the original sheet later and have it ripple through to the other page?
 
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
 
Back
Top