autosum problems

[Guest]

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(M88)
9 b 3 -2 3 -4 =SUM(M99)

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

 

[Max]

... used the "drag" down to repeat the function for each row

... only duplicates the original cell.

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

 

[Guest]

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

 

[Max]

Glad to hear that, Ryan !
Thanks for the feedback ..