SOLVED

Highlighted
New Contributor

# Counting "Pass" in a row in

How do I write a formula that can count how many times the word "Pass" comes up in a row of data? Thanks in advance.

5 Replies
Highlighted
Best Response confirmed by KattSwann (New Contributor)
Solution

# Re: Counting "Pass" in a row in

=COUNTIF(1:1,"Pass")

The above formula will count all cells with a value of "Pass" in row 1 of the sheet.
Highlighted

# Re: Counting "Pass" in a row in

Assuming you have Pass and Fail in columns A1:A100.

To count how many are pass, execute =COUNTIFS(A1:A100,"Pass").

You can also use =SUMPRODUCT(1*(A1:A100="Pass"))
Highlighted

# Re: Counting "Pass" in a row in

Thank you! @Zack Barresse

Highlighted

Thanks!
Highlighted

# Re: Counting "Pass" in a row in

I posted a solution for a row of data as that is what the OP asked for, not a column. But yes, it can of course be any range. I certainly wouldn't use a more expensive SUMPRODUCT if a COUNTIF would work, but always nice to show options I guess.