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.


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

Array enter (hit enter while control and shift are depressed)

or enter
with just hitting enter.