So it is, I checked the lengths with LEN() but I must have confused the
returned numbers. In any case it is academic because it does not work.
RagDyeR, Peo & Harlan posted working formulas so I did not bother trying to
improve it.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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.
...