Software

Ask something
Discussion Locked

Excel Sum mystery

0 helpful
6 replies

by nschloss

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
User brought me this one: have numeric values in c20:o25. In column P is the formula =sum(c20:n20)for each row 20 to 25. In column Q is the formula =sum(d20:o20)for each row 20 to 25. When entering numeric values in column O (for these rows) followed by pressing enter or down arrow, for some rows the value is entered and the cursor moves down as it should. For others, it first moves one cell to the right (col P) and changes the sum formula from cXX:nXX to cXX:oXX and then moves to the next cellin col O. Have no idea why this is happening and only on some rows. Any thoughts?

6 replies

by nschloss

No - not the problem. Actually have since discovered by further testing that Excel 2000 seems to do this by default. Tested in a new blank worksheet by recreating a similar setup. Sure enough, by filling in the number data immeditately left of the =sum function and on the right end of the existing data included in the function, Excel assumes I want to include it in the sum and adjusts the formula to include this neighboring column. Pardon my poor description. Now, how do I get it to NOT dothis?

by dklippert

Go to Tools>Options and remove the check mark from Extend list formats and formulas. That should stop it.

This discussion is closed to new replies.