Maybe some of the numbers have been formatted as text, are any of them
left-aligned instead of right-aligned? To convert text cells to number
format you will need to highlight them and use Format-Cells to set the
format to number, then click on each cell and press F2 followed by Enter as a
bug in Excel means text cells won't convert immediately back to number unless
you re-enter the data.

Andrea Jones
www.stratatraining.co.uk

"Alina Roumania" wrote:

I wanted to sum the values from an column but for some cells it doesnt sum it
to the total. Why is this?