Forum Discussion
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. ...
Internally COUNTIF converts text which looks like numbers into the numbers keeping first 15 digits
The trick could be
or you may use SUMPRODUCT() instead.