That formula looks syntactically incorrect. Can you write out what you are trying to sum in ordinary math-kinda formula or in English?
--------------------------------------------- from [email protected] :) -----Original Message----- From: "Toni & Chris PC4" <[email protected]> Date: Sun, 1 Jan 2012 17:23:45 To: <[email protected]> Reply-To: [email protected] Subject: [libreoffice-users] Ignoring text in calc formula 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 When it gets to a row with text in a cell it shows #VALUE! I have searched and =sum is supposed to fix this ?? Can you help. Thank you Toni -- 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 -- 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
