countif two variables in two different columns

Greg Diamond · May 25, 2005

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?

N Harkawat · May 25, 2005

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

Daniel CHEN · May 25, 2005

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

[email protected]
www.Geocities.com/UDQServices

Free Data Processing Add-in<

===== * ===== * ===== * =====

countif two variables in two different columns

Greg Diamond

N Harkawat

Daniel CHEN