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 **
|