[Solved] Spreadsheet Formulae

Discuss the spreadsheet application
Post Reply
Leveraa
Posts: 12
Joined: Tue Nov 10, 2015 9:28 pm

[Solved] Spreadsheet Formulae

Post 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.
Last edited by robleyd on Thu Feb 21, 2019 12:37 am, edited 2 times in total.
Open Office 4/Windows 8:1
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Spreadsheet Formulae

Post 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

=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.
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
merlijn
Posts: 29
Joined: Mon Jun 11, 2018 8:29 pm

Re: Spreadsheet Formulae

Post by merlijn »

=SUM(H45;W45)
replace the ; with :
=SUM(H45:W45)
OpenOffice 4.1.6 on Windows 10 x64
User avatar
Villeroy
Volunteer
Posts: 31270
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet Formulae

Post 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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
keme
Volunteer
Posts: 3699
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Spreadsheet Formulae

Post 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?
Leveraa
Posts: 12
Joined: Tue Nov 10, 2015 9:28 pm

Re: Spreadsheet Formulae

Post 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
Open Office 4/Windows 8:1
John_Ha
Volunteer
Posts: 9583
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Spreadsheet Formulae

Post 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 ).
LO 6.4.4.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.
Post Reply