COUNTIF not working

Occasional Visitor


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?


1 Reply


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(...)".