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
|