Finding characters

[J.J. Feminella]

I have an n by n grid of cells. Some of the cells contain numbers; some
contain the letter "E". How do I determine the number of cells in the grid
containing the letter E?

Best wishes,
JJ

 

[RagDyer]

Try this:

=COUNTIF(n:n,"E")

n:n should be a contiguous range.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



"J.J. Feminella" <(substitute as necessary) | jjf2k at virginia dot edu>
wrote in message I have an n by n grid of cells. Some of the cells contain numbers; some
contain the letter "E". How do I determine the number of cells in the grid
containing the letter E?

Best wishes,
JJ