add cells from various pages in a summary page

R

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
 
P

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
 
Top