=SUMPRODUCT(--(B1:B9999=4),--(C1:C9999=1))


"Greg Diamond" <Greg wrote in message
...
I have column b and column c, I want to count if b=4 and c=1 but if b=4 and
c=2 I don't want it to count it. Can anyone tell me how this would be
done?