Count text values in a range


In range C4:C10, assume the following values/formulas

1. Cell C4 - 1
2. Cell C5 - 2
3. Cell C6 - W
4. Cell C7 - We
5. Cell C8 - Empty cell
6. Cell C9 =IF(D9+E9=2,"a","").  Please ensure that cells D9:E9 are empty
7. Cell C10 =1/0.  This will yield the #DIV/0! error

To count numbers and text values in the range above, you may refer to my solution in this workbook.

Leave a Comment

Your email address will not be published.