autosum problems

R

Ryan

Hi

I have recently bought Office 2003 and i am using the excel part to do a
fantasy football league. In the past i have used autosum to add a range of
cells and then used the "drag" down to repeat the function for each row.
Unfortunately this now in 2003 only duplicates the original cell. I enclose
these as examples of how i think it should appear, but the program wont let
me:

Row Player Week1
+ - + - Total
8 A 3 2 3 4 =SUM(M8-N8+O8-P8)
9 B 4 3 5 6 =SUM(M9-N9+O9-P9)
or
8 A 3 -2 3 -4 =SUM(M8:p8)
9 b 3 -2 3 -4 =SUM(M9:p9)

I hope someone can help.....many thanks to anyone that can
 
M

Max

... used the "drag" down to repeat the function for each row
... only duplicates the original cell.
Click to expand...

I'm not sure whether calc mode is inadvertently set to manual
Do a quick check: Press F9 - does it compute properly?

To check / change calc mode:
Click Tools > Options > Calculation tab > Automatic > OK

And instead of writing: =SUM(M8-N8+O8-P8)
which is a little superfluous ..

Try either: =M8-N8+O8-P8
or: =SUM(M8,O8)-SUM(N8,P8)

The latter, using SUM() will retain the advantage of ignoring any text
which may be entered / evaluated within the source cells
 
R

Ryan

thanks max....worked a dream......and so did the revised
formula....appreciate it
regards ryan
 
Top