|Based on the examples you gave, I am going to assume that you are pasting the formula 2 columns to the right of the original. To get the results you want, you would need to paste the formula 4 columns to the right.|
Excel is not a mind reader. Let's say you wanted to copy/paste your original formula and end up with the N3:Q4 version directly under the original, or maybe 4 cells to the left and 1 up. How would Excel know that? It can't.
Therefore, Excel is doing the best it can by incrementing the column value by the same number of columns the pasted formula is offset from the original. I guess we could say that we're lucky that it even does that for us.
It's possible that you could write some VBA code, or maybe use an INDIRECT function, to get the formulae you want wherever you want, but a simple copy/paste is going to follow the built in rules.