Formula Question involving two columns and returning a count
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?
|