littlesister
New Member
- Joined
- Nov 27, 2008
- Messages
- 10
I'm sure this question has been asked before, but I can't find anything that answers my question.
I have a formula which contains column references that I need to copy vertically, while increasing the column reference with every new copied row.
e.g. C1 contains formula:
=SUMPRODUCT(--(Report1!$X$2:$X$10806>Report1!S$2:S$10806))
Now when I copy this formula I need the next rows to show:
D1
=SUMPRODUCT(--(Report1!$Y$2:$Y$10806>Report1!S$2:S$10806))
E1
=SUMPRODUCT(--(Report1!$Z$2:$Z$10806>Report1!S$2:S$10806))
etc...
I have a formula which contains column references that I need to copy vertically, while increasing the column reference with every new copied row.
e.g. C1 contains formula:
=SUMPRODUCT(--(Report1!$X$2:$X$10806>Report1!S$2:S$10806))
Now when I copy this formula I need the next rows to show:
D1
=SUMPRODUCT(--(Report1!$Y$2:$Y$10806>Report1!S$2:S$10806))
E1
=SUMPRODUCT(--(Report1!$Z$2:$Z$10806>Report1!S$2:S$10806))
etc...