COUNTIF with two conditions

[Jaydubs]

Hello Excel(lent) users,

I want to use countif but with two conditions, instead of one.

I tried:
=COUNTIF(AND('Data entry'!$K$2:$K$65534="Yes";'Data entry'!$C$3:$C$65534=B2))

But it did not work

 

[Special-K]

Reference to a solution here

http://www.mrexcel.com/td0128.html

 

[Toppers]

Use sumproduct (Somproduct):


=Sumproduct(--('Data entry'!$K$3:$K$65534="Yes");--('Data
entry'!$C$3:$C$65534=B2))

Should start row be 2 or 3 ? It differs in your COUNTIF statement.

HTH

 

[Jaydubs]

Thanks for the two corrections, the sumproduct as well as the starting row !

Great !