Forum Discussion
copy a consistent formula
How would I copy a consistent formula to a cell 4 columns over. Ie copy sum( a1+b1) to 4 columns over to read sum(a2+b2)
Let's say you enter the first formula in D2. Enter:
=SUM(INDEX($A$1:$B$1000, QUOTIENT(COLUMN(D2)-COLUMN($D$2), 4)+1, 0))
Copy the cell with the formula, then paste it 4 cells to the right, 8 cells to the right, etc.
Thank you for illustrating my point, Hans, that the original request isn't readily accomplished in Excel. I'll give you credit for a creative solution, but I'd still want to know the context of the request, so as to consider other possibly more straight forward solutions. 