should have looked around before I posted... found my answer:

=SUMPRODUCT(--(L4:L555="sdp"))



"CJZ" wrote:

formula to keep a running tally of the number of times a certain word appears
in a spreadsheet...

I'd like one cell that I can refer to that will always show me the number of
times SDP is listed in a spreadsheet.

Thanks in advance