Sum function not working correctly in Excel (Skips Cell)

T

Tony

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
 
T

Tony

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
IF argument limit - how convert formula to VBA? 2
Fill Series Calculations with Autofilter ON 0
Conditional formatting multiple cells from one cell to another 3
Payment calculation 1
Excel 2003 "If" function 0
Simple Calculation Bug 1
The sum of the same function that is used for a range of cells 2

Top