Functions for all worksheets
 

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

Functions for all worksheets
 

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?

Functions for all worksheets
 

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

Functions for all worksheets
 

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

Functions for all worksheets
 

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