Finding characters

J

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
 
R

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
 
Top