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? |
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 |
All times are GMT +1. The time now is 07:31 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com