Apache OpenOffice Community Forum

Posted: **Tue Feb 27, 2024 8:42 pm**

I'm using the formula =SUM (C4:C26) -- where C4:C26 represents and includes the data I'd like to total.

In the attachment, you can see the numbers I've entered and where I've entered them. What do I do after entering the numbers in order to see the correct total of the rows in the designated cell?

(Sometimes this yields =SUM (C4:C26)E27.)

: OpenOffice SUM.jpg (9.82 KiB) Viewed 1255 times

Posted: **Tue Feb 27, 2024 9:01 pm**

Place cursor where you want the answer, then enter =Sum(C2:C26), then press the Enter key.

If you get ### in the answer, you need to widen the column so it can display the all the figures of the answer.

Posted: **Tue Feb 27, 2024 10:17 pm**

I don't think my response has been posted yet, so I'll just say "thank you a lot" for this suggestion because I was not using the enter key after I typed the formula. Today I did, and it worked!

Posted: **Tue Feb 27, 2024 11:15 pm**

You can also use the green tick next to the input line to add the formula to the cell.

Apache OpenOffice Community Forum

[Solved] SUM function yields ### and #NAME?

[Solved] SUM function yields ### and #NAME?

Re: sum function yields ### and #NAME?

Re: SUM function yields ### and #NAME?

Re: [Solved] SUM function yields ### and #NAME?