Use the following array formula (end with Ctrl+Shift+Ebter):
=COUNT(IF(((Sheet3!$B$12:$B$19)=4)*((Sheet3!$C$12: $C$19)=1),Sheet3!$B$12:$B$19))
===== * ===== * ===== * =====
Daniel CHEN
www.Geocities.com/UDQServices
Free Data Processing Add-in<
===== * ===== * ===== * =====
"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?