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" <DeltaSis4@discussions.microsoft.com> wrote in message
news:20F36A8E-0AEA-4A49-9DE9-1C64CEE8B6E8@microsoft.com...
>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" <DeltaSis4@discussions.microsoft.com> wrote in message
> news:20F36A8E-0AEA-4A49-9DE9-1C64CEE8B6E8@microsoft.com...
> >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" <DeltaSis4@discussions.microsoft.com> wrote in message news:145BA522-A9C5-4A43-9084-E6284437F980@microsoft.com...
> Nothing
>
> "Niek Otten" wrote:
>
> > So what *does* appear in the cell?
> >
> > --
> >
> > Kind Regards,
> >
> > Niek Otten
> >
> > Microsoft MVP - Excel
> >
> > "DeltaSis4" <DeltaSis4@discussions.microsoft.com> wrote in message
> > news:20F36A8E-0AEA-4A49-9DE9-1C64CEE8B6E8@microsoft.com...
> > >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" <DeltaSis4@discussions.microsoft.com> wrote in message news:145BA522-A9C5-4A43-9084-E6284437F980@microsoft.com...
> > Nothing
> >
> > "Niek Otten" wrote:
> >
> > > So what *does* appear in the cell?
> > >
> > > --
> > >
> > > Kind Regards,
> > >
> > > Niek Otten
> > >
> > > Microsoft MVP - Excel
> > >
> > > "DeltaSis4" <DeltaSis4@discussions.microsoft.com> wrote in message
> > > news:20F36A8E-0AEA-4A49-9DE9-1C64CEE8B6E8@microsoft.com...
> > > >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" <DeltaSis4@discussions.microsoft.com> wrote in message news:2B160D56-FC9E-44A6-B8DA-DEF12C276A25@microsoft.com...
> =(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" <DeltaSis4@discussions.microsoft.com> wrote in message news:145BA522-A9C5-4A43-9084-E6284437F980@microsoft.com...
> > > Nothing
> > >
> > > "Niek Otten" wrote:
> > >
> > > > So what *does* appear in the cell?
> > > >
> > > > --
> > > >
> > > > Kind Regards,
> > > >
> > > > Niek Otten
> > > >
> > > > Microsoft MVP - Excel
> > > >
> > > > "DeltaSis4" <DeltaSis4@discussions.microsoft.com> wrote in message
> > > > news:20F36A8E-0AEA-4A49-9DE9-1C64CEE8B6E8@microsoft.com...
> > > > >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!!!!
> > > >
> > > >
> > > >
> >
> >
> >