dragging formulas
Hi,
Try,
=OFFSET($A$1,40,ROW(A1)+1)+OFFSET($A$1,86,ROW(A1)+ 1)+OFFSET($A$1,136,ROW(A1)+1)+OFFSET($A$1,183,ROW( A1)+1)
Here, the number after the comma immediately after $A$1 in each OFFSET
function is one less than the row number of the cell added.
Regards,
B. R. Ramachandran
"rmarks" wrote:
I am having a problem dragging down a formula. Its easier for me to give an
example rather than describe the problem. Example: The formula im trying to
drag down is: c41+c87+c137+c184. If i drag this down i will get
c42+c88+c138+c185 in the next row but the formula i result i would like for
the drag down is d41+d87+d137+d184. Any thoughts on how i can correct this?
|