View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Coderre
 
Posts: n/a
Default Totalling a group of worksheets

Try this:

On the Summary sheet, select the cell where you want the A1 summary to
display.

Type =sum(
Then click on the Sheet A tab
Hold the [Shift] key down
Click on the last sheet's tab
Release the [Shift] key
Type ) and press [Enter]

The formula should look like: =SUM(A:K!A1)


Does that help?

***********
Regards,
Ron


"BJ" wrote:

How do I summarize a continguous series of worksheets on to a summary page?
e.g. I have a number of worksheets A,B,C,.......K. I also have a summary
worksheet. I want to total cells A1 in the group of worksheets and show the
total in the summary worksheet
--
Thanks
BJ