If this will be on another sheet, use

=COUNTIF('Sheet Name'!B4:B500,"Nigel"

should have mentioned that

--
HTH

Bob Phillips

"Bob Phillips" wrote in message
...
Hi again Nigel,

Something like

=COUNTIF(B4:B5000,"Nigel")

You could put the name in another cell and refer to that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Nigel" wrote in message
...
Thank you for all of your help Bob. I would like to ask you another
question
though.
I have a long list in (range B4:B500). in this list are all of my
Clients.
(
about 50 clients in total ). the list is created by enquiry which means
the
client names are entered at random. I now need to calculate how many
enquiries from each individual client per year. i have a large sheet set
up
and cannot change the format of this. the information is to be entered
onto
anther sheet in the same book.
summary:
count the amount of times each individual clients name appears in this
long
list.

Kindest Regards,

Nigel