View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default 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