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?

Formula Question involving two columns and returning a count
 

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?

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?

Formula Question involving two columns and returning a count
 

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?

Formula Question involving two columns and returning a count
 

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 -