Formula Question involving two columns and returning a count

[bswood7]

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 D25 = Cathryn AND B2:B5 = X,
return the number of of Xs. Or in other words, how many people did Cathryn
sponsor that actually accepted?

 

[Mike H]

Maybe

=SUMPRODUCT((D26="Cathryn")*(B2:B6="x"))

Mike

 

[bswood7]

Thanks, problem solved!

Maybe

=SUMPRODUCT((D26="Cathryn")*(B2:B6="x"))

Mike

 

[Can''''''''t get it]

you could also use the "counif" function...you use it to count a column for a
specific number, letter or word, etc.

ex.: =COUNTIF(C2:C178,"x")

 

[Pete_UK]

That would count all x values in column C (Decline column), and would
not take account of the Sponsor name.

Pete