Thread: Countif does not equal
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Countif does not equal
Alan Beban wrote...
....
More responsively,

=COUNTIF(A1:A100,"<*apple*")

And on the off chance the OP wants case-sensitive matching, the array
formula

=COUNT(FIND("apple",range))
Reply With QuoteReply With Quote