Conversation SUM Function Not Working in Excel
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179886#M5104
<P>I have a spreadsheet that I created a nested if statement to fill in a number value in cell J2 "=IF(G2="L","0",IF(G2="OTL","1",IF(G2="W","2",IF(G2="",""))))" it works fine and puts the proper number in J2. It does this for cells G2:G83. The number value goes into cells J2:J83. I then used the SUM function to total the numbers in cells J2:J83 however, the sum shows as 0 instead of the actual sum. What if anything am I missing? </P>Thu, 05 Apr 2018 19:21:43 GMTMark Akesson2018-04-05T19:21:43ZSUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179886#M5104
<P>I have a spreadsheet that I created a nested if statement to fill in a number value in cell J2 "=IF(G2="L","0",IF(G2="OTL","1",IF(G2="W","2",IF(G2="",""))))" it works fine and puts the proper number in J2. It does this for cells G2:G83. The number value goes into cells J2:J83. I then used the SUM function to total the numbers in cells J2:J83 however, the sum shows as 0 instead of the actual sum. What if anything am I missing? </P>Thu, 05 Apr 2018 19:21:43 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179886#M5104Mark Akesson2018-04-05T19:21:43ZRe: SUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179934#M5111
<P>Mark</P>
<P> </P>
<P><STRONG>"1"</STRONG> is text and not a number. SUM() adds only numbers and ignores text. Change <STRONG>"1"</STRONG> to <STRONG>1</STRONG>,</P>Thu, 05 Apr 2018 21:37:13 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179934#M5111Detlef Lewin2018-04-05T21:37:13ZRe: SUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179936#M5112
<P>Thanks, that did it. I knew I was missing some stupid little obvious thing.</P>Thu, 05 Apr 2018 21:42:05 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/179936#M5112Mark Akesson2018-04-05T21:42:05ZRe: SUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/309232#M23490
<P><SPAN>I entered =SUM(E3:E9) but all it shows is 0</SPAN></P><P> </P><P><SPAN>The correct cells are addressed</SPAN></P><DIV class="">No ‘ mark</DIV><DIV class="">No space ahead of number</DIV><DIV class="">All cells are formatted as number (both source and destination) using FORMAT function.</DIV><DIV class="">There is a small triangle in upper LH side of source cells but I cannot figure what it means or how to find out.</DIV>Sat, 05 Jan 2019 04:34:27 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/309232#M23490Lee_A_W2019-01-05T04:34:27ZRe: SUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/309271#M23493
<P>Small triangle means you have a text, not numbers. If you select your cells and click on arrow within the appeared icon you'll see like</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 222px;"><img src="https://gxcuf89792.i.lithium.com/t5/image/serverpage/image-id/64731i2021B8851142F0B1/image-size/large?v=1.0&px=999" title="image.png" alt="image.png" /></span></P>
<P>You may convert to numbers from that menu, cells format will be shifted to General. Before that you may check how you cells are formatted, select them and click Ctrl+1.</P>Sat, 05 Jan 2019 10:58:31 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/309271#M23493Sergei Baklan2019-01-05T10:58:31ZRe: SUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/766767#M36868
<P><LI-USER uid="521"></LI-USER> </P><P> </P><P>Hi there - I have a similar problem as your previous poster, but have checked my cells and no text fields there, but I still get $0 for the sub-total. I've done this many times and no problem, but just can't seem to pinpoint where the issue is. I've put a red box around the culprit - hope you can help.</P><P>Regards,</P><P>Teresa</P>Mon, 22 Jul 2019 03:19:16 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/766767#M36868TeresaHan2019-07-22T03:19:16ZRe: SUM Function Not Working
https://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/766828#M36869
<P><LI-USER uid="379876"></LI-USER> </P><P>It is not clear which cell you are referring to but your spreadsheet has a circular reference in AL4:AL8. That may be the cause.</P><P> </P>Mon, 22 Jul 2019 04:38:36 GMThttps://techcommunity.microsoft.com/t5/excel/sum-function-not-working/m-p/766828#M36869Detlef Lewin2019-07-22T04:38:36Z