Hi everybody!
I am working with an excel sheet where I need to count several values if they are fulfilling different criteria. As for now I believe my formula is correct, but it does not count all values and it seems like this is because of some of the values are exactly the same for different persons.
The formula looks like this:
=SUM(COUNTIFS($O$84:$O$593;{"TS-PSF";"TS- PSF"};$M$84:$M$593;{"ACTIVE";"SICK"}))
There is supposed to be 15 that fulfills these criteria, but it only counts 13.

I would appreciate all help! Thank you in advance.