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