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