Excel : Counting on two columns

A

adhar jain

THIS IS AN MICROSOFT EXCEL QUESTION: URGENT

Suppose I have two columns "A" and "B".
"A" "B"
Error Open
Error Closed
Not Error Open
Error Open
Error Closed
------------------
------------------

----- -> Represents blank rows..

How will I find Error which are open in columns 0-7
(including blank rows)
 
B

beeawwb

Try putting this into C1

=SUMPRODUCT((A1:A65535="Error")*(B1:B65535="Open"))

Hope it helps,

-Bo
 
Top