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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Opening Excel in 2 different windows 2007 1
*** Recommendation needed *** Which desktop or motherboard supports fast CPU and Windows 98 6
*** Recommendation needed *** Which desktop or motherboard supports fast CPU and Windows 98 18
"Stuck pixels" appear only on XP desktop? 13
Checking the inverter board and CCFL lamp for a HP ProBook 4530sNotebook PC running Windows 7 Profes 6
best LCD monitor(s) to buy - please help 20
Reduction Fractions to LCD 7
What's it take -- 3rd monitor? 3

Back
Top