Thread: count 2 column
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jason Au Yeung Jason Au Yeung is offline
external usenet poster
 
Posts: 1
Default count 2 column

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