J
Jodie
How do I total each column in a worksheet for all worksheets in a workbook?
B
Bob I
Use =SUM() at the end of each column of data.
S
Susan
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
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
L
Luke M
See "3d references" in XL help file. Something like this:
=SUM('Sheet1:Sheet3'!A:A)
=SUM('Sheet1:Sheet3'!A:A)
J
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.
a macro. I have my answer already, but thank you all for your help.