Forum Discussion

Mark Akesson's avatar
Mark Akesson
Copper Contributor
Apr 05, 2018

SUM Function Not Working

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 numbe...
excel
Lee_A_W's avatar
Lee_A_W
Copper Contributor
Jan 05, 2019

I entered =SUM(E3:E9) but all it shows is 0

 

The correct cells are addressed

No ‘ mark
No space ahead of number
All cells are formatted as number (both source and destination) using FORMAT function.
There is a small triangle in upper LH side of source cells but I cannot figure what it means or how to find out.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 05, 2019

    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

    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.

    • TeresaHan's avatar
      TeresaHan
      Copper Contributor
      Jul 22, 2019

      SergeiBaklan 

       

      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.

      Regards,

      Teresa

      • Detlef_Lewin's avatar
        Detlef_Lewin
        Silver Contributor
        Jul 22, 2019

        TeresaHan 

        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.

         

Resources