Count if?

[Hannah]

Good afternoon

Please could you tell me if there is any way to count all the cells that are
not equal to a value or to count all those cells that contain text?

Many thanks

Hannah

 

[Pete_UK]

To count values in column A not equal to 15, for example:

=COUNTIF(A:A,"<>15")

Hope this helps.

Pete

 

[Ms-Exl-Learner]

Have a look in Countif, Count & Counta functions in the below link...

http://www.contextures.com/xlFunctions04.html

If this post helps, Click Yes!

 

[Hannah]

Thank you - thta's brilliant!

To count values in column A not equal to 15, for example:

=COUNTIF(A:A,"<>15")

Hope this helps.

Pete



.