Hi Paul,

Thanks for reply. I am not sure if I've been specific enough (excuse my
Excel ignorance). The column 'E' has peoples names from cell '6' onwards
(some cells can have several names). Basically I want to 'find' how many
times e.g. 'Donnelly' has been entered in that column (or whole spreadsheet).
I put your formula into 'E1' with no success...

To me it is more of a specific 'word' count that I need to do...I am not
even sure if this is available in 'Word' (another question!)...

Thanks for your help,
Paul


"Paul Black" wrote:

Hi donners6,

Assuming there are NO Names that you want to Find in Column "A", Insert
this Formula in Cell "A1" :-
=COUNTIF(B:IV,"=Donnelly")

Hope this Helps.
All the Best.
Paul