View Single Post
  #1   Report Post  
PullingMyHairOut
 
Posts: n/a
Default 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