Apache OpenOffice Community Forum

Posted: **Thu Jul 14, 2011 6:59 pm**

Hello,
I have run into a problem I can't seem to figure out. I'm trying to use the SUM formula to add up totals on 12 sheets within one spreadsheet document and I don't know how to do that. I can use that SUM formula for each sheet but what I need is the total amount from all 12 sheets to calculate on a separate sheet. How do I do that? Please help.

[SOLVED]

Posted: **Thu Jul 14, 2011 7:06 pm**

Hi and welcome to the forum!

Can't you put a mere equal sign (to start the formula) and then select the cells in the different sheets with a plus between each?

Please add '[Solved]' at the beginning of your first post title (edit button) if your issue has been fixed.

Posted: **Thu Jul 14, 2011 7:16 pm**

Did you want to sum the same range of all the sheets ?

If yes, for example with A1:A10 in 12 sheets (January to December) :

Code: Select all

=SUM(January.A1:December.A10)

sum cells A1 to A10 for all sheets from January to December.

Apache OpenOffice Community Forum

[Solved] Calculate the SUM total from multiple sheets

[Solved] Calculate the SUM total from multiple sheets

Re: How do I calculate the SUM total from multiple sheets?

Re: How do I calculate the SUM total from multiple sheets?