Counting number of similar names

[cadeson]

I have a table with names in it such as "Admin 1", "Admin 2", "Admin 3" etc and wish to count how many entries contain the text Admin. Could somebody help me please, its probably very simple but I am stumped.[/i][/b]

 

[BrianB]

The COUNTIF() function accepts wildcards (in this case the asterisk) so
=COUNTIF(A1:A100,"Admin*")

 

[cadeson]

Thankyou very much Brian, I had a go at wildcards ( hangover from some basic programming a long time aga, but I must have been doing something wrong because it works like a treat. Thank you I knew it would be a simple answer but you have saved me a lot of time.