Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Summing same cell/cells from multiple sheets
I am creating a report with a summary sheet which will contain the totals of
many subsheets. I have seen a formula that sums the same cell from multiple sheets without having to go to each sheet and do a formula like +"cell refernece"+"cell refernece".... I can not remeber the formula. Any help is apprecaited Thanks |
#2
|
|||
|
|||
Try
=SUM(first:last!A10) apply as follows: type equal sign, select the first sheet that you want to be included, hold down shift key and select the last sheet, click in the cell you want to sum, press enter. -- Regards, Peo Sjoblom "Dave" wrote in message ... I am creating a report with a summary sheet which will contain the totals of many subsheets. I have seen a formula that sums the same cell from multiple sheets without having to go to each sheet and do a formula like +"cell refernece"+"cell refernece".... I can not remeber the formula. Any help is apprecaited Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
editing multiple sheets at once | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
How do I unhide multiple sheets? | Excel Worksheet Functions |