Thread: Countif does not equal
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default Countif does not equal
Teethless mama wrote:
=COUNTIF(A1:A100,"<apple")


"JRD" wrote:


How to count the number of cells in a column which do not contain a certain
text string?

More responsively,

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

Alan Beban
Reply With QuoteReply With Quote