Forumla required

[Fred Hill]

I have a display as such

A B F G
FRED YES FRED
JIM JIM
FRED YES JANET
FRED
JANET YES
JIM

I need a formula to tell me in COL G how many times the names in COL F show
a YES in col B.
As you can see all the names in COL F are the unique names from Col A
For example in this case FRED should read 2 in Col G and JIM reading zero
and Janet reading 1

Thanks for the help

 

[Don Guillett]

Look in the help index for COUNTIF

 

[Mike H]

Fred,

Put this in g1 and drag down

=SUMPRODUCT(($A$1:$A$20=F1)*($B$1:$B$20="Yes"))

Mike

 

[Fred Hill]

Excellent work Mike. Works as requested. I guess I'll need to read up on
SUMPRODUCT more to totally understand it.