Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
add cells from various pages in a summary page
XL2003; I've forgotten how to summarize different page totals to a "wrap-up"
page. Say pages 1, 2, 3, etc., all have totals. I want to add those together on page "x." I used to know how, but I've completely forgotten. many thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
add cells from various pages in a summary page
=SUM('1:3'!A10)
it's easiest if you let excel do the job, on the summary sheet type =SUM( then click the first sheet tab, hold down shift and click the last sheet tab, click the cell with the totals and press enter -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "roger" wrote in message ... XL2003; I've forgotten how to summarize different page totals to a "wrap-up" page. Say pages 1, 2, 3, etc., all have totals. I want to add those together on page "x." I used to know how, but I've completely forgotten. many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
FU: Distribute info from "summary" page to separate pages under condition | Excel Worksheet Functions | |||
How I can combine cells of different pages? | Excel Discussion (Misc queries) | |||
How can I copy a cell from one page to all pages of a workbook? | Excel Worksheet Functions |