Countif with more than 1 condition

bakerman

Board Regular
Joined
Sep 9, 2005
Messages
188
I understand how to use the countif function but now i'm stuck. How do you use countif to look for more than one condition
an example of what I am trying to do
=COUNTIF(J13:M13,"H")
=COUNTIF(J13:M13,"L")
=COUNTIF(J13:M13,"Sh")
Can I replace the above formulas with one formula
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,645
Members
410,627
Latest member
georgealice
Top