Excel formule question, lookup and count

[Lammers73]

Hello,

Hope someone can help me out. I just cant solve it.

I have 2 colums filed with data:

Column 1 has a variety of names (lets say Pete, James, etc).
Column 2 has a result: "Passed" or "Failed"
Each Row is a registration of a test

So
Row 1 Pete failed
Row 2 James passed
Row 3 Pete passed

What I want to have in excel is to look up in column 1 all registrations under pete, and then (1) count the number of "passed" of all Pete's registrations and (2) give a % of the passed on the total registrations of Pete in all rows.
So I get Pete has 13 Passed with a Pass% of 75%

Thanks for your time and help!

 

[Joe4]

To get the count of "passed" records for Pete, you can use a formula like:

=COUNTIFS(A:A,"Pete",B:B,"passed")

To get the percentage of "passed" records for Pete, you can use a formula like:

=COUNTIFS(A:A,"Pete",B:B,"passed")/COUNTIF(A:A,"Pete")

 

[Lammers73]

Excellent! You are great! Thanks for your quick response!

 

[Joe4]

You are welcome.
Glad I was able to help!