overlapping sums gives incorrect results

[Guest]

I'm using excel 2000. I have a rectangular array of numbers and I sum accross and dow
repeatedly. When I use the autosum function (sigma) I sometimes get incorrect results
For example, I have 2,2,2 accross the top and 3,3,3 in column underneath the first 2
I sum accross the top to get 6 and down to get 11. Then I put a four in one of the empty cell
and sum accross to get 7. Then I sum down that column to get 10. Now, when I su
accross THAT row I sometimes just get 7 and so on. What is going on

 

[Frank Kabel]

I'm using excel 2000. I have a rectangular array of numbers and I
sum accross and down repeatedly. When I use the autosum function
(sigma) I sometimes get incorrect results.
For example, I have 2,2,2 accross the top and 3,3,3 in column
underneath the first 2.
I sum accross the top to get 6 and down to get 11. Then I put a four
in one of the empty cells and sum accross to get 7. Then I sum down
that column to get 10. Now, when I sum
accross THAT row I sometimes just get 7 and so on. What is going on?

Hi Mark
not sure what you're doing, but why not enter the SUM formulas
manually. I suppose Excels autosum function is not that intelligent you
'want' it to be. The autosum function will (AFAIK) only sum adjacent
cells. Blanks rows in between will be used as 'range stop'

Frank

 

[Frank Kabel]

Hi Mark
that is the reason I don't use autosum. You cannot be sure what it will
create. So maybe it's a bug (though MS will declare it as a feature
Frank

 

[Guest]

Mark
When you use the autosum button, Excel suggests a range. You don't have to accept it. You can use your mouse to sweep a different range if the suggested one isn't what you want

Regards
Mark Graesse
(e-mail address removed)

----- Mark wrote: ----

It doesn't seem to matter if I use blank cells or not. I've also found ou
that the same occurs with Excel 2002. Take a row or column of number
and do overlapped sums using autosum. Sometimes it just copies the last number over

I know you can use formulae and so forth but I'd like to know if this is a bu
or some setting within Excel so I can tell users what the issue is