I think you want something like this:

=SUMPRODUCT(--(C4:C250=2);--(D2:D250=1))


Rodrigo Ferreira


"Jenelle1433" escreveu na mensagem
...
I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??