[Solved] Please tell me whats wrong with this formula

Discuss the spreadsheet application

[Solved] Please tell me whats wrong with this formula

Postby blakemulder » Mon Jul 27, 2020 10:12 pm

=SUM(S7)+W3-W9-W10-W11-W12-W13-W14-W15-W16-W17-W18-W19-W20-W33-W34-W35-W36-W37

I want to simplify this but when I try to condense it (w9:w37) I get error #VALUE!

Driving me nuts

any help very much appreciated

Blake
Last edited by robleyd on Tue Jul 28, 2020 12:12 pm, edited 1 time in total.
Reason: Tagged [Solved]
OPENOFFICE 4.17
WIN 10
blakemulder
 
Posts: 2
Joined: Mon Jul 27, 2020 10:08 pm

Re: Please tell me whats wrong with this formula

Postby FJCC » Mon Jul 27, 2020 10:29 pm

This should work:
Code: Select all   Expand viewCollapse view
=S7 + W3 - SUM(W9:W20) - SUM(W33:W37)

If W21:W32 are empty, you can use
Code: Select all   Expand viewCollapse view
=S7 + W3 - SUM(W9:W37)
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: 7970
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Please tell me whats wrong with this formula

Postby blakemulder » Tue Jul 28, 2020 11:09 am

Brilliant! You have something that I dont - BRAINS! Thankyou
OPENOFFICE 4.17
WIN 10
blakemulder
 
Posts: 2
Joined: Mon Jul 27, 2020 10:08 pm


Return to Calc

Who is online

Users browsing this forum: manoman and 31 guests