My results don't appear in the cell

[Guest]

I am using a Sum IF(ISTEXT)) formula. I already know the formula is correct
because the results appear correctly in the Function Arguments pop-up box.
However, I can't get the results to appear in the cell. Help!!!!

 

[Niek Otten]

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[Guest]

Nothing

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

 

[David McRitchie]

As you can tell there aren't many mindreaders here.

But we're getting better at pulling teeth.

What is the formula and what are the values it is looking at.
Provide information so that a question can be answered.

 

[Guest]

=(SUM(IF(ISTEXT(C6:AE6),0.5,0)))

As you can tell there aren't many mindreaders here.

But we're getting better at pulling teeth.

What is the formula and what are the values it is looking at.
Provide information so that a question can be answered.

 

[David McRitchie]

You can't have a range of more than once cell for ISTEXT.
even if you had all text values in every cell you would get False

Value is the value you want tested. Value can be a blank (empty cell), error, logical, text, number, or reference value, or a name
referring to any of these, that you want to test.

=IF(ISTEXT(C6:AE6),0.5,0)
ISTEXT will alwasys be false
so you get 0 from that.
So surround that with sum simply gets 0.

That was more fun than pulling teeth.

 

[Max]

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>

 

[Guest]

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]

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

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