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?