=SUMPRODUCT(--(B1:B100="trainee_name"),--(J1:J100="word"))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Sukh" wrote in message
...
Dear All,

I have a spreadsheet with aroung 12, 500 lines. The sheet contains info
about trainees and values recieved for training. I wanted to count the
number of times a specific word, located in column J appeared against each
trainee.

Trainees are identified by a unique code in column B. Any help would be
greatly appreciated.

Thanks