=SUMPRODUCT(--(C4:C250=2),--(D4:250 =1))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Jenelle1433" wrote in message
...
I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??