Maybe

=SUMPRODUCT((D2:D6="Cathryn")*(B2:B6="x"))

Mike

"bswood7" wrote:

I need help with a formula for a project I am working on... A sample of what
I need is below.

Accept Decline Sponsor
Alicia x Cathryn
Brandy x Cathryn
Katie x Elizabeth
Jason x Cathryn
Kelly x Elizabeth

So, I want a function that basically says, If D2:D5 = Cathryn AND B2:B5 = X,
return the number of of Xs. Or in other words, how many people did Cathryn
sponsor that actually accepted?