Finding characters

  • Thread starter Thread starter J.J. Feminella
  • Start date Start date
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
 
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
 
Back
Top