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

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

Hope this helps.

Pete

On Nov 13, 3:13*pm, Hannah wrote:
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