Formulas

[Bob]

I have 10 worksheets in a workbook. One of the sheets is a totals
sheet that will show the totals from the 9 other worksheets and the
total them.

What does the formula look like to place a formula (SUM a3:a30) or the
number it gets as a total from one sheet into another sheet?

I am looking to show the totals of the 9 sheets and then get a grand
total.

Any help would be provided.

Answer here or directly to (e-mail address removed)

Thanks alot
Bob

 

[Peo Sjoblom]

Try


=SUM(first_sheet:last_sheet!A1:A10)

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

 

[CLR]

On Sheet1, put these formulas........

=SUM(Sheet2!A1:A30)............this will get you the total from Sheet2
=SUM(Sheet3!A1:A30)............this will get you the total from Sheet3, etc
etc

then just sum them up for a grand total..........

Vaya con Dios,
Chuck, CABGx3

 

[Bob]

I have 10 worksheets in a workbook. One of the sheets is a totals
sheet that will show the totals from the 9 other worksheets and the
total them.

What does the formula look like to place a formula (SUM a3:a30) or the
number it gets as a total from one sheet into another sheet?

I am looking to show the totals of the 9 sheets and then get a grand
total.

Any help would be provided.

Answer here or directly to (e-mail address removed)

Thanks alot
Bob

Thank you for your responses. After doing those I still could not get
the number to appear, just the formulas. THEN..........I remembered
that I had checked that option to help me see the formulas. Once I
unchecked it the numbers appeared and all worked well. One of those
DUH! moments

Sometimes it takes those who are away from the trees to see the
forest. Thanks for all the help.

Bob