count 2 column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
=sumproduct(--(A1:A10="Open"),--(B1:B10='Desktop"))
adjust the range to suit ur needs.
EricBB
 
Back
Top