I need help with a =sum IF ISTEXT formula. I keep getting 0.
 

I'm using the following formula to add up the number of times I have text in
a cell. However, whenever I extend the range I get 0.

=SUM(IF(ISTEXT(C28:L28),1,0))

For example, if I extend the range to M28 I get 0.

If you're able to figure out this question, I would like to add .5 to the
total.

Any suggestions or help would be greatly appreciated.

Thank you in advance,

Dick

=SUMPRODUCT(--(ISTEXT(C28:M28)))*0.5

is a better way of doing it and it can be entered normally but it wouldn't
explain the zero result, works fine for me when testing

--
Regards,

Peo Sjoblom


"PullingMyHairOut" wrote in
message ...
I'm using the following formula to add up the number of times I have text
in
a cell. However, whenever I extend the range I get 0.

=SUM(IF(ISTEXT(C28:L28),1,0))

For example, if I extend the range to M28 I get 0.

If you're able to figure out this question, I would like to add .5 to the
total.

Any suggestions or help would be greatly appreciated.

Thank you in advance,

Dick

As Peo implied, your formula is an array formula that must be array
entered (Ctrl-Shift-Enter) in order to work.

Jerry

PullingMyHairOut wrote:

I'm using the following formula to add up the number of times I have text in
a cell. However, whenever I extend the range I get 0.

=SUM(IF(ISTEXT(C28:L28),1,0))

For example, if I extend the range to M28 I get 0.

If you're able to figure out this question, I would like to add .5 to the
total.

Any suggestions or help would be greatly appreciated.

Thank you in advance,

Dick