ISTEXT not working?

Giganews Newsgroups
Subject: ISTEXT not working?
Posted by:  Amer Neely (perl4hi…@softouch.on.ca)
Date: Sat, 06 Jan 2007

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

Replies