Sum function not working correctly in Excel (Skips Cell)

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

Guest

I have one cell that is not included in a sum function. This repeats in
several worksheets. e.g. =SUM(C6:C11) Cell C7 is not added in the list.
If I type in the formula =C6+C7+C8+C9+C10+C11 it will give the correct result.

Thanks in Advance
 
Hi Tony,

C7 has a number formatted as TEXT, change it. Then the Sum function will
work.

Paul
 
Thanks, that did it. Just a note... I did have to retype the value in the
cell for it to recognize it.
 
Tony

That is correct and Don and Paul could have mentioned that.

Just changing the format will not change the text to number.

Re-enter as you did or if you have a great whack of these you can copy an
empty cell formatted as General or Number then select your great whack and
Paste Special>Add>OK>Esc.

This forces them into numbers.

Gord Dibben Excel MVP
 

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

Need a function 1
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Conditional formatting multiple cells from one cell to another 3
Sumproduct + Array Function? 4
If Functions 2
Function Bug ? 8
Embarrassing question about lookup. 4
Using AND or OR in a IF formula 3

Back
Top