Thread: Countif range contains part of a value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
antwaan antwaan is offline
external usenet poster
  
Posts: 5
Default Countif range contains part of a value
I have a range of cells in column A. The values may range from:
10041, 10041B to 10041PEM

I need a formula to count the number of "41" that occurs. Please help!

Reply With QuoteReply With Quote