How do I total each column in a worksheet for all worksheets in a workbook?
--
Thank you, Jodie

Use =SUM() at the end of each column of data.

Jodie wrote:
How do I total each column in a worksheet for all worksheets in a workbook?

you can select one worksheet, then, holding down Ctrl select the rest
of the worksheets. now they are all grouped. whatever you do to one
worksheet will be done on all the other worksheets. so if your
columns all end *around* row 100, then in row 110 you could enter

=sum(a1:a109)

then drag it over to the right for the approximate number of columns
each worksheet has.

when you're done, select one different worksheet to ungroup them.
hope that helps.
:)
susan


On Oct 26, 3:13*pm, Jodie wrote:
How do I total each column in a worksheet for all worksheets in a workbook?
--
Thank you, Jodie

See "3d references" in XL help file. Something like this:

=SUM('Sheet1:Sheet3'!A:A)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jodie" wrote:

How do I total each column in a worksheet for all worksheets in a workbook?
--
Thank you, Jodie

Thank you all. I was not clear in my question as I was looking to do this in
a macro. I have my answer already, but thank you all for your help.
--
Thank you, Jodie


"Luke M" wrote:

See "3d references" in XL help file. Something like this:

=SUM('Sheet1:Sheet3'!A:A)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Jodie" wrote:

How do I total each column in a worksheet for all worksheets in a workbook?
--
Thank you, Jodie