I'm not sure if the expression
=SUM(IF(ISTEXT(C6:AE6),0.5,0))
was meant to be array-entered
(Press CTRL+SHIFT+ENTER)
which then seems to work as intended ??
> That was more fun than pulling teeth.
ROTFL! I've got only a set of dentures, btw.
No need to pull, just take out / wash / put back. <bg>
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
Bookmarks