Forumla required

F

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
 
M

Mike H

Fred,

Put this in g1 and drag down

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

Mike
 
F

Fred Hill

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