SOLVED

Counting "Pass" in a row in

%3CLINGO-SUB%20id%3D%22lingo-sub-1341347%22%20slang%3D%22en-US%22%3ECounting%20%22Pass%22%20in%20a%20row%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341347%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20I%20write%20a%20formula%20that%20can%20count%20how%20many%20times%20the%20word%20%22Pass%22%20comes%20up%20in%20a%20row%20of%20data%3F%20Thanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1341347%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341368%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20%22Pass%22%20in%20a%20row%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341368%22%20slang%3D%22en-US%22%3E%3DCOUNTIF(1%3A1%2C%22Pass%22)%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20above%20formula%20will%20count%20all%20cells%20with%20a%20value%20of%20%22Pass%22%20in%20row%201%20of%20the%20sheet.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341396%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20%22Pass%22%20in%20a%20row%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341396%22%20slang%3D%22en-US%22%3EAssuming%20you%20have%20Pass%20and%20Fail%20in%20columns%20A1%3AA100.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20count%20how%20many%20are%20pass%2C%20execute%20%3DCOUNTIFS(A1%3AA100%2C%22Pass%22).%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20also%20use%20%3DSUMPRODUCT(1*(A1%3AA100%3D%22Pass%22))%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1341537%22%20slang%3D%22en-US%22%3ERe%3A%20Counting%20%22Pass%22%20in%20a%20row%20in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1341537%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10842%22%20target%3D%22_blank%22%3E%40Zack%20Barresse%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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
=COUNTIF(1:1,"Pass")

The above formula will count all cells with a value of "Pass" in row 1 of the sheet.
Highlighted
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

Thank you! @Zack Barresse 

Highlighted
Thanks!
Highlighted
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.