You may have numbers formatted as text, these won't sum using the sum
function. You can convert a range of text "numbers" to numeric with the
following process.

Put a 1 in any empty cell and copy that cell.
Select your range of "numbers".
Edit Paste Special under "operation" select "add"

Now your SUM should work

another way without touching your data. Instead of

=SUM(A1:A10) use

=SUMPRODUCT(--A1:A10)

"tom" wrote:

i'm not an expert but i would first check the format of the cell that in
which you are creating the sum . hope this helps until an expert comes
along!!!
--
TomMurray


"Caroline" wrote:

I am calcualting sums as normal in Excel but my totals when using the SUM
function are coming to 0 instead of the actual figure - 10,000. This is only
ocurring in some cells and not others.

I have checked the calculation tab in Options - Tools is automatic and it
seems ok.

PLEASE help!!