Sum function not working correctly in Excel (Skips Cell)

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
 
P

Paulw2k

Hi Tony,

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

Paul
 
G

Guest

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

Gord Dibben

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
Conditional formatting multiple cells from one cell to another 3
Sumproduct + Array Function? 4
Function Bug ? 8
Embarrassing question about lookup. 4
Using AND or OR in a IF formula 3
Text box does not populate linked cell 2
Formula to auto calculate based on other variables 8

Top