Sandy Mann wrote:
"Aladin Akyurek" wrote in message
...

=(COUNTIF($M$1:$M$4999,"OK")=ROWS($M$1:$M$4999)) +0



Aladin,

May I ask, when you have hard coded $M$4999 into the formula and
ROWS($M$1:$M$4999) returns 4999, why did you not just use =4999?

I thought that it was to account for inserted rows above the data but if you
insert 10 rows the fomula automatically changes to:

=(COUNTIF($M$11:$M$5009,"OK")=ROWS($M$11:$M$5009)) +0

and the ROWS($M$11:$M$5009) of course still evaluates to 4999


If rows in between would be deleted for some reason, the formula would
break down, hence ROWS(...).