Forum Discussion

Raghenie Radjkoemar's avatar
Raghenie Radjkoemar
Copper Contributor
Mar 27, 2018

Formules do not work

hi all,     When I insert formules to count the values of cells or if I want to refer to another cell, I get the wrong values/amounts.   I tried to count the amounts with the auto sum formula...
Excel on Mac
SergeiBaklan's avatar
SergeiBaklan
MVP
Mar 27, 2018

Hi,

 

AutoSum uses COUNT() function which count only the cells with numbers, all the rest are ignored. Is that your case?

  • Raghenie Radjkoemar's avatar
    Raghenie Radjkoemar
    Copper Contributor
    Mar 27, 2018

    hi it doesnt even count numbers.. while in other worksheets the formulas works at it should. I assume it is a settings-issue..?

    • SergeiBaklan's avatar
      SergeiBaklan
      MVP
      Mar 27, 2018

      If you check any of your cells which you try to count with ISNUMBER() what it returns?

Resources