add cells from various pages in a summary page

[roger]

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

[Peo Sjoblom]

=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" <roger@discussions.microsoft.com> wrote in message
news:61FC50AE-7994-4271-ACC9-8FEA831F0D17@microsoft.com...
> 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