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

[PullingMyHairOut]

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

 

[Peo Sjoblom]

=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

 

[Jerry W. Lewis]

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

Jerry