Apache OpenOffice Community Forum

I want to add totals from 14 columns to put grand total in 15th column. Calculation is =SUM(H45;W45). But all I get is error 508. What am I doing wrong. SOLVED.

Your formula should not give an error unless one of the cells H45 or W45 contains an error. However, it will only give you the sum of those two cells. If you want the sum of all of the cells from H45 to W45, use the formula Notice it is a colon between the two cell names. If you are still getting an error, look at all of the individual cells to see if any contain an error.

=SUM(H45;W45)

replace the ; with :
=SUM(H45:W45)

menu:Help>About... should give us a hint which software you are running actually.


=SUM(H45:W45) sums the cells between H45 and W45
=SUM(H45;W45) sums two cell values H45 and W45 in all versions of Apache OpenOffice Calc. Err:508 indicates that you are running LibreOffice

Err.:508 is "unmatched pair", and the most common cause I see is when a formula contains too many closing parentheses. This is not caused by the formula you posted. If that is the actual formula in use, the error has propagated from one of the summed cells.

The range H45:W45 spans 16 columns, while you stated that you need to sum 14 columns. You either made a mistake or you are not telling us the full story (which can also be regarded a mistake). What are you working on?

I want to arrive at a total of all cols from and including H45 to W45, that is all 14 columns. How should I type the formulae

If you type =SUM( in the cell you can then drag from H45 to W45 and Calc enters the correct range formula. Now type the closing ).