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

Pete

On Mar 25, 12:53*pm, Can''''''''t get it
wrote:
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")



"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?- Hide quoted text -

- Show quoted text -