Thread: Countif range contains part of a value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Countif range contains part of a value
=COUNTIF(A:A,"*41*")

If this post helps click Yes
---------------
Jacob Skaria


"antwaan" wrote:

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