Forum Discussion
Help with Countif with multiple criteria
I may only confirm that COUNTIFS() in Excel works correctly - millions of people around the globe use it and have correct results.
It's hard to say what's wrong in your case without concrete example.
SergeiBaklan Many thanks for getting back to me sir.
The issue is this,
I want to count the number of tests were positive for a particular test out of about 400 sample cohort. I therefore used COUNTIFS where I set first range,then the first criteria (excel gives me a value for this first part) but when I set the second range and second criteria, I get a 0.
I have used the COUNTIFS function already as part of the audit I am doing so I know it should work, I just don't know why this one isn't.
Again, the question is a bit abstract. Perhaps you may provide some sample of not working properly function?