... 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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ryan" wrote in message
...
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