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
