Check cell formats and contents in B2:B8. SUM() will not add numbers within cells formatted as text or numbers preceded by a half quote. Per below the sum() result is 4 as such items are not summed.
4 '=SUM(B2:B8) 2 Cell number format with '2 (note the half quote) 3 Cell number format with '3 (note the half quote) 5 Cell formatted as text. 1 Cell number format with 1 1 Cell number format with 1 1 Cell number format with 1 1 Cell number format with 1 On Wed, May 11, 2016 at 12:03 PM, shirish शिरीष <shirisha...@gmail.com> wrote: > Hi all, > > I was trying a simple addition in column =SUM(B2:B8) > > but that didn't work . I am getting the output as zero. > > Could somebody look at it and share what is/was wrong ? > > Sharing an example worksheet for the same. > -- > Regards, > Shirish Agarwal शिरीष अग्रवाल > My quotes in this email licensed under CC 3.0 > http://creativecommons.org/licenses/by-nc/3.0/ > http://flossexperiences.wordpress.com > EB80 462B 08E1 A0DE A73A 2C2F 9F3D C7A4 E1C4 D2D8 > > -- > To unsubscribe e-mail to: users+unsubscr...@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 > -- To unsubscribe e-mail to: users+unsubscr...@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
