One way: =SUMPRODUCT((C4:C250=2)*(D4:D250=1))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jenelle1433" wrote:
I need formula: count C4:C250 if it contains a 2 only if D4:250 contains a
1. Is it Possible??