COUNTIF is 0 - Two values in the same column

[alaa_mjd]

Hello,
It seems that my formula is not counting 2 different values in the same column. The only calculation that worked was one with identical values.
Can you share a method to associate multiple values to the same "label"? My plan is to use SUMIF using the label values later on..

=COUNTIFS($A$2:$A$12,A15,$A$2:$A$12,B15,$B$2:$B$12,"Yes")
A15= {Label}
B15= {Department}

Thanks in advance!
Al

 

[Fluff]

What exactly are the values in A15 & B15?

 

[alaa_mjd]

Hi @Fluff ,
A15= a value in {Label} column
B15= a value in {Department} column

 

[Peter_SSs]

Your formula in row 15 is trying to count how many times "Business Operations", "Business Ops" and "Yes" are found in the same row in rows 2:12.
There are no rows where that is true and hence the count is 0.

1. Please explain in words exactly what you are trying to do.
2. What result do you want/expect in row 15 and why?

 

[alaa_mjd]

The sheet has several jobs under the each department. I want to demonstrate the highest outsourcing arrangements in each department.
My plan is to count the "Yes" in C15 column then SUMIF the results based on their "Labels".

 

[Peter_SSs]

My plan is to count the "Yes" in C15

.. based on what?

You did not answer this question

What result do you want/expect in row 15 and why?

 

[alaa_mjd]

I did "My plan is to count the "Yes" in C15 column then SUMIF the results based on their "Labels"."

 

[Peter_SSs]

My plan is to count the "Yes" in C15 column

That is easy then (though I don't believe for a moment that it is what you want)

=COUNTIF(B2:B12,"Yes")

then SUMIF the results based on their "Labels"."

There are no numbers anywhere in the sample data so any SUMIF based on that sample data will return 0.
Again though, I don't believe that is what you actually want, but you are not clarifying what you do want.


You did not answer the question about what actual answer you expect in row 15.

 

[bebo021999]

With A15 = "Business Operationd" and B15 = "Business Ops"
your formula:
=COUNTIFS($A$2:$A$12,A15,$A$2:$A$12,B15,$B$2:$B$12,"Yes")
attemp to look for row where:
cell in B contains "Yes"
cell in A contains A15 AND B15 at the same time (imposible)

So, if you want to count rows where ("Yes" in col B) and (A15 OR B15) in col A
It should be 2 COUNTIFs:

=COUNTIFS($A$2:$A$12,A15,$B$2:$B$12,"Yes")+COUNTIFS($A$2:$A$12,B15,$B$2:$B$12,"Yes")