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