ISTEXT not working?

A

Amer Neely

I'm trying to use 'ISTEXT' with 'SUM' but it doesn't seem to be working.

Excel 2002 on Win2K.

A worksheet I downloaded (from Microsoft) using the formula works fine,
but when I try to use it in another sheet, it gives me 0.

[C4]
=SUM(IF(ISTEXT(C7:C43),1,0))

c7:c16 contain 'Ashley'
c17:c43 contain nothing

Anyone care to take a stab at this and figure out why it's not working?
--
Amer Neely
w: www.softouch.on.ca/
b: www.softouch.on.ca/blog/
Perl | MySQL programming for all data entry forms.
"We make web sites work!"
 
G

Guest

As a formula, your example returns zero
As an array formula, your example returns 10
 
B

Bob Phillips

You can shorten it too

=SUM(--(ISTEXT(C7:C43)))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


Gary''s Student said:
As a formula, your example returns zero
As an array formula, your example returns 10
--
Gary's Student


Amer Neely said:
I'm trying to use 'ISTEXT' with 'SUM' but it doesn't seem to be working.

Excel 2002 on Win2K.

A worksheet I downloaded (from Microsoft) using the formula works fine,
but when I try to use it in another sheet, it gives me 0.

[C4]
=SUM(IF(ISTEXT(C7:C43),1,0))

c7:c16 contain 'Ashley'
c17:c43 contain nothing

Anyone care to take a stab at this and figure out why it's not working?
--
Amer Neely
w: www.softouch.on.ca/
b: www.softouch.on.ca/blog/
Perl | MySQL programming for all data entry forms.
"We make web sites work!"
Click to expand...
Click to expand...
 
G

Guest

Very nice and compact
--
Gary's Student


Bob Phillips said:
You can shorten it too

=SUM(--(ISTEXT(C7:C43)))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


Gary''s Student said:
As a formula, your example returns zero
As an array formula, your example returns 10
--
Gary's Student


Amer Neely said:
I'm trying to use 'ISTEXT' with 'SUM' but it doesn't seem to be working.

Excel 2002 on Win2K.

A worksheet I downloaded (from Microsoft) using the formula works fine,
but when I try to use it in another sheet, it gives me 0.

[C4]
=SUM(IF(ISTEXT(C7:C43),1,0))

c7:c16 contain 'Ashley'
c17:c43 contain nothing

Anyone care to take a stab at this and figure out why it's not working?
--
Amer Neely
w: www.softouch.on.ca/
b: www.softouch.on.ca/blog/
Perl | MySQL programming for all data entry forms.
"We make web sites work!"
Click to expand...
Click to expand...
Click to expand...
 
D

Dave Peterson

And sometimes, it's easier to not have to remember to use ctrl-shift-enter:

=SUMPRODUCT(--ISTEXT(C7:C43))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUM across named sheets 11
Function Bug ? 8
Fomula result not displaying 2
Macro paste values help 5
Vlookup, COUNTIF, IF or Nested 1
error with code 4
Circular Ref was working fine - now :( 2
query design approach suggestions 8

Top