Forum Discussion

Marc DeWitt's avatar
Marc DeWitt
Copper Contributor
Dec 20, 2017

SUM Function not working

I have several nested IF statements in cells b4:g4 that display different  #'s based on the value of another cell. When I do =SUM(B4:G4), it displays 0. Is there a way I can fix this?
Formulas & Functions
Need Help
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Dec 20, 2017

Hi Marc,

 

Please be sure your cells are formatted as numbers, not text. You may check by =ISNUMBER(B4), etc.

  • Marc DeWitt's avatar
    Marc DeWitt
    Copper Contributor
    Dec 20, 2017

    I have the cells formatted as a number, but the ISNUMBER function reports false.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Dec 20, 2017

      Without sample it's hard to say why do you have the text. As variant your IF could return text

       

Resources