Count if?
 

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

Count if?
 

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

Count if?
 

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

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

If this post helps, Click Yes!

--------------------
(Ms-Exl-Learner)
--------------------



"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

Count if?
 

Thank you - thta's brilliant!

"Pete_UK" wrote:

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

.