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