How do I copy the following formula down without incrementing the 2nd cell reference in each bracket;
=SUM((R5*D38)+(S5*D39)+(T5*D40))
Currently it copies down like this;
=SUM((R6*D39)+(S6*D40)+(T5*D41))
And I would like it to copy down like this;
=SUM((R6*D38)+(S6*D39)+(T6*D40))
Thanks if you can help.
Bookmarks