counting number of occurrences of certain values in a range - Excel 2010
Posted on 2013-11-14
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
I would like to now count "HIGH" and "LOW"