My results don't appear in the cell

Thank you Max!! That worked. The spreadsheet was a template the worked
before I started adding columns. I will remember this trick for the future!!

"Max" wrote:

> 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
> ----
>
>
>

You're welcome !
Glad it worked for you ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"DeltaSis4" <DeltaSis4@discussions.microsoft.com> wrote in message
news:130700AA-C9C9-4A42-94E9-2E489F10490E@microsoft.com...
> Thank you Max!! That worked. The spreadsheet was a template the worked
> before I started adding columns. I will remember this trick for the
future!!