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