Thread
:
Countif statement
View Single Post
#
1
Steved
Posts: n/a
Countif statement
Hello from Steved
How do I have the below work, I want Yes to be displayed if
Column does not have OK in the M Column please.
=IF(COUNTIF($M$1:$M$4999,"<OK"), "YES","NO")
The above formula resides in Cell L1
Thankyou.
Reply With Quote