Forum Discussion

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. ...

excel

Excel on Mac

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
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?
- LxGwy2024
  Copper Contributor
  Jun 25, 2024
  HansVogelaar
  column is is concatation of a thru H...so all values in column J should be 1.
  - SergeiBaklan
    MVP
    Jun 25, 2024
    LxGwy2024
    
    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.