Need help with formula

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Just Me - 17 Jan 2006 21:52 GMT

I have a workbook that has about 20-30 worksheets in it. There is one column
in every worksheet that has a total, is there a way to have all the totals
from the worksheets show up on one worksheet as a grand total.

Thanks in advance

Reply to this Message

doodle - 17 Jan 2006 21:58 GMT

If the sheets were named 1-30, and your cell with total was A1, use
this formula:

=SUM('1:30'!A1)

-doodle

Reply to this Message

Roger Govier - 17 Jan 2006 22:01 GMT

Hi

Insert 2 new sheets. Name one as first the other as last.
Drag them to positions which encompass the range of 30 sheets you want
total, with your summary sheet outside of this "sandwich".
=SUM(First:Last!A100) or whatever cell on each sheet is holding your
column total.
Moving the positions of first and last will allow you to summarise
whatever range of sheets you want, without having to change the formula.

Signature

Regards

Roger Govier

>I have a workbook that has about 20-30 worksheets in it. There is one
>column in every worksheet that has a total, is there a way to have all
>the totals from the worksheets show up on one worksheet as a grand
>total.
>
> Thanks in advance

Reply to this Message