That formula looks syntactically incorrect. Can you write out what you are trying to sum in ordinary math-kinda formula or in English? --------------------------------------------- from twohot@device.mobile :) -----Original Message----- From: "Toni & Chris PC4" <tscrivin@talktalk.net> Date: Sun, 1 Jan 2012 17:23:45 To: <users@global.libreoffice.org> Reply-To: users@global.libreoffice.org 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: users+help@global.libreoffice.org 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: users+help@global.libreoffice.org 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