ISTEXT not working?

Giganews Newsgroups
Subject: ISTEXT not working?
Posted by:  Amer Neely (perl4hi…
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.


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
Perl | MySQL programming for all data entry forms.
"We make web sites work!"