=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
[Solved] Please tell me whats wrong with this formula
-
- Posts: 4
- Joined: Mon Jul 27, 2020 10:08 pm
[Solved] Please tell me whats wrong with this formula
Last edited by robleyd on Tue Jul 28, 2020 12:12 pm, edited 1 time in total.
Reason: Tagged [Solved]
Reason: Tagged [Solved]
OPENOFFICE 4.17
WIN 10
WIN 10
Re: Please tell me whats wrong with this formula
This should work:
If W21:W32 are empty, you can use
Code: Select all
=S7 + W3 - SUM(W9:W20) - SUM(W33:W37)
Code: Select all
=S7 + W3 - SUM(W9:W37)
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.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
-
- Posts: 4
- Joined: Mon Jul 27, 2020 10:08 pm
Re: Please tell me whats wrong with this formula
Brilliant! You have something that I dont - BRAINS! Thankyou
OPENOFFICE 4.17
WIN 10
WIN 10