#### littlesister

##### New Member

- Joined
- Nov 27, 2008

- Messages
- 10

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...