Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i reference multiple rows/columns with one function?
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Is there a forumla to link an absolute cell reference in multiple. | Excel Worksheet Functions | |||
Cell Reference Math | Excel Worksheet Functions | |||
Incrementing rows (or columns) to a reference in another worksheet | Excel Worksheet Functions | |||
How do I reference multiple rows | Excel Worksheet Functions |