counting number of occurrences of certain values in a range - Excel 2010

I have values in some columns in range D14:G35 that can be blank, "HIGH" or "LOW".  I would like to count the occurences of "HIGH" and "LOW".  How can I do this.

When I just checked for one value, I used
=COUNTIF(C15:G45,"HIGH")

I would like to now count "HIGH" and "LOW"
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
You can add 2 COUNTIF together

=COUNTIF(C15:G45,"HIGH")+COUNTIF(C15:G45,"LOW")

or you can do it this way.

=SUM(COUNTIF(C15:G45,{"HIGH","LOW"})
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.