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
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 05, 2018

Mark

 

"1" is text and not a number. SUM() adds only numbers and ignores text. Change "1" to 1,

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

    Thanks, that did it.  I knew I was missing some stupid little obvious thing.

Resources