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