[Solved] Copying formulae from cells

[kieranoh]

Hello,

I have a spreadsheet that has lots of columns of totals that include calcs such as the followings:

=SUMPRODUCT(I6:I5834=O15;E6:E5834=1)

Cell O15 is a Heading and below, from O16 to O50, I have more headings.

If I do a standard copy and paste of the above onto line 16, I get this:

=SUMPRODUCT(I7:I5835=O16;E7:E5835=1)

So, it has moved O15 onto O16, which is great BUT it also incremented the I and E cells, which I do not want.

I can obviosuly manullay update the cells, but there are lots of them!

So, the question is:
Is there a way that I can copy =SUMPRODUCT(I6:I5834=O15;E6:E5834=1) and for it to become =SUMPRODUCT(I6:I5834=O16;E6:E5834=1)

Thanks for any help.

Kieran

[robleyd]

Use absolute or mixed references where needed. See [Tutorial] Absolute, relative and mixed references

[kieranoh]

Excellent. Thanks!

Kieran