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 शिरीष <shirishag75@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+unsubscribe@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+unsubscribe@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