XL2003; I've forgotten how to summarize different page totals to a quot;wrap-upquot;
page. Say pages 1, 2, 3, etc., all have totals. I want to add those
together on page quot;x.quot; I used to know how, but I've completely forgotten.
many thanks
=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
quot;rogerquot; gt; wrote in message
...
gt; XL2003; I've forgotten how to summarize different page totals to a
gt; quot;wrap-upquot;
gt; page. Say pages 1, 2, 3, etc., all have totals. I want to add those
gt; together on page quot;x.quot; I used to know how, but I've completely forgotten.
gt;
gt; many thanks
- Jul 16 Mon 2007 20:38
add cells from various pages in a summary page
close
全站熱搜
留言列表
發表留言