count 2 column

J

Jason Au Yeung

I would like to count following criteria. Do there any formula can help IN
Excel ?

Closed LCD
Closed LCD
Open LCD
Open LCD
Open LCD
Open Desktop
Open Desktop

I would like to get the total which is (Open , Desktop). In this case, it
should be 2.

Thanks very much
 
E

EricBB

=sumproduct(--(A1:A10="Open"),--(B1:B10='Desktop"))
adjust the range to suit ur needs.
EricBB
 
Top