Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Recap Worksheet
I've created a workbook with 12 worksheets. The 12th one is a recap (total
of the previous 11) sheet. I need cell C2 to populate the total of cells C2 the previous 11 sheets. I've been unable to find the correct formula to make this calculate correctly. Any help would be greatly appreciated. |
#2
|
|||
|
|||
Select C2 in the recap sheet, then type
=SUM( select first sheet and hold down shift and select the last sheet you want to include (assuming it is the second but last previous to the recap) click in C2, press enter -- Regards, Peo Sjoblom (No private emails please) "Rob D" <Rob wrote in message ... I've created a workbook with 12 worksheets. The 12th one is a recap (total of the previous 11) sheet. I need cell C2 to populate the total of cells C2 the previous 11 sheets. I've been unable to find the correct formula to make this calculate correctly. Any help would be greatly appreciated. |
#3
|
|||
|
|||
Rob, how about
=SUM(Sheet1:Sheet11!C2) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Rob D" <Rob wrote in message ... I've created a workbook with 12 worksheets. The 12th one is a recap (total of the previous 11) sheet. I need cell C2 to populate the total of cells C2 the previous 11 sheets. I've been unable to find the correct formula to make this calculate correctly. Any help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
copyright and worksheet protection | Excel Discussion (Misc queries) |