For adding those up you can use this formula:

=SUMPRODUCT(--(A1:A7="FN")+--(A1:A7="FP")+--(A1:A7="AGREE"))

Where A1:A7 is the range of data you want to search for those keyword
in. If one of the words is found it adds one.

if A1:A7 was:
dfns
FN
FP
AGREE
sdfp
FN
FP
it would return the value 5.

Best of luck to you

--
Ikaabo
-----------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...fo&userid=3337
View this thread: http://www.excelforum.com/showthread.php?threadid=54120