Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum function not working correctly in Excel (Skips Cell)
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 |
#3
|
|||
|
|||
Hi Tony,
C7 has a number formatted as TEXT, change it. Then the Sum function will work. Paul "Tony" wrote in message ... 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 |
#4
|
|||
|
|||
Thanks, that did it. Just a note... I did have to retype the value in the
cell for it to recognize it. "Don Guillett" wrote: c7 is TEXT. change -- Don Guillett SalesAid Software "Tony" wrote in message ... 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 |
#5
|
|||
|
|||
glad to help.
-- Don Guillett SalesAid Software "Tony" wrote in message ... Thanks, that did it. Just a note... I did have to retype the value in the cell for it to recognize it. "Don Guillett" wrote: c7 is TEXT. change -- Don Guillett SalesAid Software "Tony" wrote in message ... 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 |
#6
|
|||
|
|||
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 SpecialAddOKEsc. This forces them into numbers. Gord Dibben Excel MVP On Mon, 29 Nov 2004 14:23:03 -0800, "Tony" wrote: Thanks, that did it. Just a note... I did have to retype the value in the cell for it to recognize it. "Don Guillett" wrote: c7 is TEXT. change -- Don Guillett SalesAid Software "Tony" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions | |||
Excel - option to extend function in cell to column | Excel Worksheet Functions | |||
Replace function not working properly in Excel 2000 SP3 | Excel Worksheet Functions | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |