My results don't appear in the cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!!!!
 
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.
 
=(SUM(IF(ISTEXT(C6:AE6),0.5,0)))

David McRitchie said:
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.
Click to expand...
 
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.
 
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.
Click to expand...
ROTFL! I've got only a set of dentures, btw.
No need to pull, just take out / wash / put back. <bg>
 
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!!
 
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 said:
Thank you Max!! That worked. The spreadsheet was a template the worked
before I started adding columns. I will remember this trick for the
Click to expand...
future!!
 
Back
Top