Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum same cell from all sheets
I remember seeing this somewhere but can't find it.
How do I sum the same cell in all sheets without clicking on every sheet? Thanks! -- JNW |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum same cell from all sheets
Use this formula:
=SUM('First Sheet:Last Sheet'!A1) Substitute First Sheet and Last Sheet with your actual sheet names. One trick to use is to insert two new worksheets and name them BEGIN and END. Place BEGIN before all other sheets, and END after all other sheets. You can then hide these new worksheets. That way, you can use the formula: =SUM(BEGIN:END!A1) Then if you ever need to add/remove worksheets, you won't need to worry about changing your formula. HTH, Elkar "JNW" wrote: I remember seeing this somewhere but can't find it. How do I sum the same cell in all sheets without clicking on every sheet? Thanks! -- JNW |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum same cell from all sheets
Type
=Sum( Click first sheet, hold down shift and click the last sheet, click the cell and press enter will give something like =SUM(Sheet1:Sheet10!E1) but with your sheet names of course -- Regards, Peo Sjoblom "JNW" wrote in message ... I remember seeing this somewhere but can't find it. How do I sum the same cell in all sheets without clicking on every sheet? Thanks! -- JNW |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Naming sheets from a cell value | Excel Discussion (Misc queries) | |||
Help on Adding the same cell in different sheets. | Excel Worksheet Functions | |||
How do I add (=Sum) the same cell for multiple sheets (103) | Excel Worksheet Functions | |||
Number of worksheet tabs as cell value? ie 4 work sheets = 4 cell value | Excel Discussion (Misc queries) | |||
i need to make the sheets name come from a cell | New Users to Excel |