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


"Jason Au Yeung" wrote:

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