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.

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top