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

Look in the help index for COUNTIF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Fred Hill" wrote in message
...
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

Fred,

Put this in g1 and drag down

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

Mike

"Fred Hill" wrote:

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

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

"Mike H" wrote:

Fred,

Put this in g1 and drag down

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

Mike

"Fred Hill" wrote:

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