Counting cells containing text

Posted by JJ on August 23, 2001 9:04 AM

I'm trying to figure out how to count the number of times I have an entry in a column that *starts* with the letters "Ped". I think I've gotten close, but no luck so far.

Posted by Mark W. on August 23, 2001 9:16 AM

=COUNTIF(A1:A10,"Ped*")

Posted by jj on August 23, 2001 9:26 AM

of course, that couldn't have been any simpler. Thanks for the help. I'll remember the * part now! :)