Lost me with the last few but thanks all!
Sandy

"Rick Rothstein (MVP - VB)" wrote in
message ...
=SIGN(COUNTIF(C7:U7,0)-(L7=0)=0)*(COUNTIF($C$8:$U$8,0)-($L$8=0))
...
=NOT(COUNTIF(C7:U7,0)-(L7=0))*(COUNTIF($C$8:$U$8,0)-($L$8=0))

They are equivalent...

SIGN(FALSE) = SIGN(0) = NOT(1)

SIGN(TRUE) = SIGN(1) = NOT(0)

Yeah, but the second is 3 chars shorter.

LOL... yeah, I have to give you that; but remember, I was patching what
you posted, not what you were thinking.<g

Rick