[Solved] Spreadsheet Formulae

Discuss the spreadsheet application

[Solved] Spreadsheet Formulae

Postby Leveraa » Fri Feb 15, 2019 4:42 pm

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

Postby FJCC » Fri Feb 15, 2019 4:48 pm

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: 7204
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Spreadsheet Formulae

Postby merlijn » Fri Feb 15, 2019 5:07 pm

=SUM(H45;W45)

replace the ; with :
=SUM(H45:W45)
OpenOffice 4.1.6 on Windows 10 x64
merlijn
 
Posts: 27
Joined: Mon Jun 11, 2018 8:29 pm

Re: Spreadsheet Formulae

Postby Villeroy » Fri Feb 15, 2019 5:09 pm

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.x
User avatar
Villeroy
Volunteer
 
Posts: 26874
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet Formulae

Postby keme » Tue Feb 19, 2019 1:48 am

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?
User avatar
keme
Volunteer
 
Posts: 3185
Joined: Wed Nov 28, 2007 10:27 am
Location: Egersund, Norway

Re: Spreadsheet Formulae

Postby Leveraa » Wed Feb 20, 2019 5:29 pm

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

Postby John_Ha » Wed Feb 20, 2019 8:43 pm

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 ).
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6649
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 27 guests