Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum values from the listed sheets
Hi everybody,
I'm having a little problem with my excel table. I have many sheets for entering data, they look exactly the same, just the sheet name is different. Then I also have the summary sheets, that are also the same as the one for data entry, just they contain formulas to sum data from data entry sheets. So what I'm trying to make a list of data entry sheets in the summary sheet and then the formula that would sum all the data entered in the listed sheets in the same cell address where the formula is located. The list of sheets to sum could contain let's say up to 30 places. And another quick question. Is it possible to somehow link make some kind of "master formula" and then use it in multiple cells, so when you change the master formula all the cells that use it change too. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do use listed pathname to link values from another workbook? | Excel Discussion (Misc queries) | |||
Find values not listed in two sheets | Excel Discussion (Misc queries) | |||
hiding zero values on all sheets & by default on new sheets | Excel Worksheet Functions | |||
I need to run queries against values in other sheets | Excel Discussion (Misc queries) | |||
Min and Max values from over 200 sheets | Excel Discussion (Misc queries) |