Or if you're looking for "Utility - " in that range and it could be buried in
with other text:

=SUMPRODUCT(--(start_rep:Finish_rep=B4),
--ISNUMBER(SEARCH("Utility - ",start:finish)))


=search() is not case sensitive.
=find() is case sensitive.



Looping through wrote:

I am tring to count the number of time a specific text appears in a range.
The following formula counts the total number of entries in my range but is
not seperating the specific text I want. Can anyone help with this?

=SUMPRODUCT(--(Start_Rep:Finish_Rep=B4)--(Start:Finish="*Utility - *"))

Thanks
Peter

--

Dave Peterson