try
=COUNTIF(P$3:P$33,"*M*")
you may? not get desired results

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
just wondering if there is a way to use these with the trim function.

=COUNTIF(P$3:P$33,"M")

so that it would work if the range contains a space or spaces along with
the letter M.
--


Gary