View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default Count if criteria is not equal to

If you mean ignore cell entries with 'C' try the below formula

=COUNTA(A:I)-COUNTIF(A:I,"C")

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


"Raquel" wrote:

I am trying to do a count if statement where my criteria will not meet "C" -
so in column A - I want it to count all letters that are not equal to "C".