Counting X's

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

I am using the formula to non number contents in cells:
=COUNTA(D3:D46)
but I need to now count only the letter x in the column.
How do I modify this formula or is it even the right one?
Thanks
Jim
 
If the "X" is *not* a stand alone character, use this:

--

HTH,

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

=COUNTIF(D3:D46,"*X*")


I am using the formula to non number contents in cells:
=COUNTA(D3:D46)
but I need to now count only the letter x in the column.
How do I modify this formula or is it even the right one?
Thanks
Jim
 
Back
Top