Hi Toni,
Toni & Chris PC4 schrieb:
Hello,
I use this formula in calc on a large forecast spreadsheet
=sum(e4+d5)-(b5+c5)
There has to be some cells with text but the text is not being ignored
That is right. The operators + - * / calculate only with true numbers.
When it gets to a row with text in a cell it shows #VALUE!
I have searched and =sum is supposed to fix this ??
Yes it does. Text is treated as 0 for function SUM and as 1 for function
PRODUCT.
Can you help.
In your special case you can use
=SUM(E4;D5)-SUM(B5:C5)
Kind regards
Regina
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
