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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
As Peo implied, your formula is an array formula that must be array
entered (Ctrl-Shift-Enter) in order to work.

Jerry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF-ISTEXT formula 6
Help with another formula, please 3
For Mike H 2
Excel formula, sum the value cell and if empty cell left blank 0
IF AND ISTEXT ISBLANK formula 5
formula explanation 3
Help Writing a SUM Formula 5
#VALUE error add'g formulas 1

Back
Top