Thread: Sumproduct?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Looping through Looping through is offline
external usenet poster
 
Posts: 69
Default Sumproduct?

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