MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Count if


Posted by Alex Shahidi on February 12, 2002 11:54 AM

What formula would accomplish the following:

a1 = Jan
a2 = Feb
a3 = Mar

b1 = On
b2 = Off
b3 = On

Result = 1

I want to countif column A = Mar AND column B = On. Thanks.

Alex


Posted by IML on February 12, 2002 12:00 PM

Array enter (hit enter while control and shift are depressed)
=SUM((A1:A3="mar")*(B1:B3="on"))

or enter
=SUMPRODUCT((A1:A3="MAR")*(B1:B3="on"))
with just hitting enter.