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 |
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 |
All times are GMT +1. The time now is 11:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com