Forum Discussion
Help with Countif with multiple criteria
Good morning, I am working on an excel document and want to use the COUNTIFS option to help me get some data. However I keep getting an error message although I am putting in the right formula. Any ...
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?