## [Solved] Spreadsheet Formulae

Discuss the spreadsheet application

### [Solved] Spreadsheet Formulae

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.
Last edited by robleyd on Thu Feb 21, 2019 12:37 am, edited 2 times in total.
Open Office 4/Windows 8:1
Leveraa

Posts: 12
Joined: Tue Nov 10, 2015 9:28 pm

### Re: Spreadsheet Formulae

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.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator

Posts: 7534
Joined: Sat Nov 08, 2008 8:08 pm

### Re: Spreadsheet Formulae

=SUM(H45;W45)

replace the ; with :
=SUM(H45:W45)
OpenOffice 4.1.6 on Windows 10 x64
merlijn

Posts: 28
Joined: Mon Jun 11, 2018 8:29 pm

### Re: Spreadsheet Formulae

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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.4

Villeroy
Volunteer

Posts: 27880
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

### Re: Spreadsheet Formulae

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?

keme
Volunteer

Posts: 3305
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

### Re: Spreadsheet Formulae

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
Open Office 4/Windows 8:1
Leveraa

Posts: 12
Joined: Tue Nov 10, 2015 9:28 pm

### Re: Spreadsheet 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 ).
LO 6.3.5.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer

Posts: 7376
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK