Count if criteria is not equal to

  • Thread starter Thread starter Raquel
  • Start date Start date
R

Raquel

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".
 
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
 
Back
Top