Is there a way to use the COUNTIF function to count cells if they contain a single letter - for example below, when a cell has the letter A, the count would be 3 in the top row
<tbody>
</tbody>
I thought it would be easy using wildcards, but is doesn't seem to work... and I think having two letters in the cell makes things worse!
Thanks for helping!
3 | ||
12345 | ||
A4567 | ||
3546 | ||
23A78 | ||
765 | ||
2A6A8 |
<tbody>
</tbody>
I thought it would be easy using wildcards, but is doesn't seem to work... and I think having two letters in the cell makes things worse!
Thanks for helping!
Last edited: