close

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()