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