CountIf Formula with Multiple Criteria in the Same Column

Anthony Barthelemy

Smartsheet Community:

I amnot sure what I am doing wrong but I am trying to Count the Number of Test Case if it Meets this Criteria:

John Doe

Test Case in Status of Pass, Fail, or Re-Test Needed

Here is my Current Formula that is Yielding 0 even though the Number should be 4:

=COUNTIFS({UAT Test Cases v2 Range 1}, "John Doe", {UAT Test Cases v2 Range 2}, "Pass", {UAT Test Cases v2 Range 2}, "Failed", {UAT Test Cases v2 Range 2}, "Retest Needed")

Paul Newcome

Try this instead...

=COUNTIFS({UAT Test Cases v2 Range 1}, "John Doe", {UAT Test Cases v2 Range 2}, OR(@cell = "Pass", @cell = "Failed", @cell = "Retest Needed"))

Paul Newcome

Try this instead...

=COUNTIFS({UAT Test Cases v2 Range 1}, "John Doe", {UAT Test Cases v2 Range 2}, OR(@cell = "Pass", @cell = "Failed", @cell = "Retest Needed"))

Anthony Barthelemy

Excellent, Worked Perfectly!

Paul Newcome

Happy to help! 👍️

skanj670

I am trying to get a count by Lead Trainer but the formula doesn't include if there are multiple Lead Trainers in the same column.

Example, for Bryson Crittenden, it is counting 1 versus 3

=COUNTIF([Lead Trainer]:[Lead Trainer], "Bryson Crittenden")

Genevieve P.

Hi @skanj670

If you're looking in a multi-select column, you'll want to use the HAS function to see if the cell has that option along with others.

For example:

=COUNTIF([Lead Trainer]:[Lead Trainer], HAS(@cell, "Bryson Crittenden"))

See: https://help.smartsheet.com/function/has

Cheers,

Genevieve