COUNTIF with two conditions
 

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
--
** Fool on the hill **

COUNTIF with two conditions
 

Reference to a solution here

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


--
Special-K


------------------------------------------------------------------------
Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470
View this thread: http://www.excelforum.com/showthread...hreadid=562759

COUNTIF with two conditions
 

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" wrote:

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
--
** Fool on the hill **

COUNTIF with two conditions
 

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

Great !
--
** Fool on the hill **


"Toppers" wrote:

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" wrote:

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
--
** Fool on the hill **