My results don't appear in the cell
 

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

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DeltaSis4" wrote in message
...
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!!!!

Nothing

"Niek Otten" wrote:

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DeltaSis4" wrote in message
...
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!!!!

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DeltaSis4" wrote in message ...
Nothing

"Niek Otten" wrote:

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DeltaSis4" wrote in message
...
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!!!!

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

"David McRitchie" wrote:

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DeltaSis4" wrote in message ...
Nothing

"Niek Otten" wrote:

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DeltaSis4" wrote in message
...
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!!!!

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DeltaSis4" wrote in message ...
=(SUM(IF(ISTEXT(C6:AE6),0.5,0)))

"David McRitchie" wrote:

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"DeltaSis4" wrote in message ...
Nothing

"Niek Otten" wrote:

So what *does* appear in the cell?

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"DeltaSis4" wrote in message
...
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!!!!

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

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

You're welcome !
Glad it worked for you ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"DeltaSis4" wrote in message
...
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!!