=SUMPRODUCT(--(criterium for A),--(criterium for B))
Give more details on criteria if you don't succeed!

Regards,
Stefi

€žgoayimm€� ezt Ã*rta:

Hi,

if I have 2 lines of data say, A and B.

I need to count num of data that fulfill both X criteria in A row and Y
criteria in B row.

How do I do that?

Thanks.