Page 1 of 1

[Solved] Spreadsheet Formulae

PostPosted: Fri Feb 15, 2019 4:42 pm
by Leveraa
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.

Re: Spreadsheet Formulae

PostPosted: Fri Feb 15, 2019 4:48 pm
by FJCC
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
Code: Select all   Expand viewCollapse view
=SUM(H45:W45)

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.

Re: Spreadsheet Formulae

PostPosted: Fri Feb 15, 2019 5:07 pm
by merlijn
=SUM(H45;W45)

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

Re: Spreadsheet Formulae

PostPosted: Fri Feb 15, 2019 5:09 pm
by Villeroy
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

Re: Spreadsheet Formulae

PostPosted: Tue Feb 19, 2019 1:48 am
by keme
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?

Re: Spreadsheet Formulae

PostPosted: Wed Feb 20, 2019 5:29 pm
by Leveraa
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

Re: Spreadsheet Formulae

PostPosted: Wed Feb 20, 2019 8:43 pm
by John_Ha
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 ).