Counting number of entries in a range?

**r055c** · 10-20-2008, 03:29 PM

Hi Guys.

I'm working on a report for work and i need to be able to count the entries from within a range.

I've searched the web (and here) but can only find out how to bring back the number of UNIQUE entires. My problem is that I'm wanting to find multiple entries.

This may be easier if i show you what i mean

Data:
--------------------

Bloggs1
Bloggs2
Bloggs3
Becham1
Becham2
Becham3

How can i get this so that it will search for all entires that have the value 'Bloggs' in it?

I know it will probably be easier by counting the all the bloggs separately and then adding them together but i'm sure there must be an easier way

Thanks in advance

**MartinShort** · 10-20-2008, 03:41 PM

Try using the CountIf function. Assuming your range is copied to A3:A8, it would look like the below; anything starting with bloggs. If you needed to, you could put another wildcard "*" at the beginning of the search string.

=COUNTIF(A3:A8,"bloggs*")

HTH
Martin

**r055c** · 10-20-2008, 03:42 PM

I can't believe it was that simple. been pulling my hair out at work all day trying to figure that out.

The * did come into my head but thought that was too simple so never give it ago.

Thanks for the help

**malnahar** · 10-20-2008, 04:06 PM

Hi,
Thank you every body.

I may require some explanation on the above if you please, what is (wildcard "*" at the beginning of the search string), would you please provide an example

Thanks