Collective Sum

[Hatter]

I have a very simple table and for some strange reason the collective sum =SUM(CX7:CX63) will not provide the correct sum, yet if I add each line separately using + then it works. But also I'm seeing another issue when dragging a formula down, instead of blank it will duplicate the result from the cell where the drag begins. Not seen these before, is it a program error/bug or me?

 

[arthurbr]

=SUM(CX7:CX63) will not provide the correct sum

And what does it return that is different from the other way?

instead of blank it will duplicate the result from the cell where the drag begins

Is your calculation set to "Automatic" instead of " Manual"?

 

[Hatter]

And what does it return that is different from the other way?

Is your calculation set to "Automatic" instead of " Manual"?

found the issue, thanks

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[Hatter]

issues linked to format of cells, even though format looked correct, it was down to the formulas used to gather data, was using REPT or SUM, changed to VLOOKUP and all worked.