Countif cell is not equal to

[slinky192001]

Hello

In column A i have a list of words. I want to create a countif that will count the number of cells not equal to "Today". When i try and do this using the below, it is also counting the blank cells in column A. How can i get it to ignore the blank cells?

=COUNTIF(A:A, "<> Today")
Thank YOu

 

[duboost]

=COUNTA(A:A)-COUNTIF(A:A,"Today")

 

[Aladin Akyurek]

Hello

In column A i have a list of words. I want to create a countif that will count the number of cells not equal to "Today". When i try and do this using the below, it is also counting the blank cells in column A. How can i get it to ignore the blank cells?

=COUNTIF(A:A, "<> Today")
Thank YOu

=COUNTIF(A:A,"?*")-COUNTIF(A:A,"Today")

yields a text count excluding formula blanks (i.e., "") and the string "Today".

 

[slinky192001]

Perfect Thank You

 

[Aladin Akyurek]

Perfect Thank You

You are welcome. Thanks for providing feedback.