Count if not a number
It seems to be 4 characters longer than your previous formula, Sandy? I
wondered whether you meant shorter in execution time, but I would have
doubted it.
--
David Biddulph
"Sandy Mann" wrote in message
...
Slightly shorter:
=SUM(COUNT(AI7:AT7),--ISBLANK(AI7:AT7))=SUM(COUNTA(AI7:AT7),--ISBLANK(AI7:AT7))
"Sandy Mann" wrote in message
...
=COUNT(AI7:AT7)+SUM(ISBLANK(AI7:AT7))=COUNTA(AI7:A T7)+SUM(ISBLANK(AI7:AT7))
Agan TRUE or FALSE. If you want something else then use it as the test
of an IF() formula.
....
|