Formula Question involving two columns and returning a count
Thanks, problem solved!
"Mike H" wrote:
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?
|