Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get the sum value for every worksheet
Let say I got more than 20 worksheets in a workbook.
In B2 of Sheet1, I want a sum value of A1 in every worksheet. Insteed of add up with '+' sheet by sheet. Any faster way for it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Get the sum value for every worksheet
It's good practice to insert a sheet called Start before the first
'real' sheet and a sheet called End after the last 'real' sheet, then use a formula like =SUM(Start:End!A1) to get your result. This will add A1 values in ALL sheets between the Start and End sheets - that way you can insert or delete sheets between Start & End and the formula will still work. Rgds, ScottO "Kelvin Lee" wrote in message ... | Let say I got more than 20 worksheets in a workbook. | In B2 of Sheet1, I want a sum value of A1 in every worksheet. | Insteed of add up with '+' sheet by sheet. Any faster way for it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect Workbook vs Worksheet?? | Excel Worksheet Functions | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |