View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bswood7 bswood7 is offline
external usenet poster
 
Posts: 2
Default 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?