Forum Discussion

emmaswa's avatar
emmaswa
Copper Contributor
Apr 26, 2023

COUNTIF not working

Hello!

I am working on a project where I am analyzing a data set on excel. I am trying to count the total number of skiers from each nationcode by using the COUNTIF function, but it is not working. I am following all the instructions online on how to add in the range of cells as well as the criteria. When I press enter for excel to do the calculations the text with the "=COUNTIF(K2:K12393;L2:L97)" remains in the cell as if it is a text. 

Does anyone know how I solve this issue?

 

excel
Excel on Mac
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 26, 2023

    emmaswa 

    Make sure that the cell in which you enter the formula is NOT formatted as Text, but as General or as Number.

    Make sure that the Show Formulas button in the Formula Auditing group of the Formulas tab of the ribbon is NOT highlighted.

    Make sure that your formula is =COUNTIF(...) and not "=COUNTIF(...)".

  • dhnluzi's avatar
    dhnluzi
    Copper Contributor
    Jun 21, 2024

    did you manage to solve the problem? i have the same problem and have spent around two hours without success emmaswa 

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Jun 21, 2024

      dhnluzi 

      We never heard back from emmaswa 

      Did you look at my suggestions? If they don't help:

      Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources