autosum problems
 

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

... 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

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

"Max" wrote:

... 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

Glad to hear that, Ryan !
Thanks for the feedback ..
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Ryan" wrote in message
...
thanks max....worked a dream......and so did the revised
formula....appreciate it
regards ryan