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.
Count text values in a range
{ 0 Comments }