count ?'s

N

Neuther

So i was wondering if there was a way to use the count w/ specifi
letters

like in 1 cell can i have it count all the a's, all the b's-g's.
know i can you count(a) and it will count text but can i specif
specific text for it to count
 
R

RagDyer

You can use the "*" wildcard.

=COUNTIF(A1,"*a*")
OR
If you would like to use a specific cell to designate a character, so that
it could be easily changed:

=COUNTIF(A1,"*"&$B$1&"*")

--

HTH,

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

So i was wondering if there was a way to use the count w/ specific
letters

like in 1 cell can i have it count all the a's, all the b's-g's. I
know i can you count(a) and it will count text but can i specify
specific text for it to count.
 
Top