Autoincrements

[Dave]

Hi,

I have a formula, eg =SUM(C4, C5)

Ok so I want to fill down the column so that C4 is incremented, but C5 stays
the same.

So eg

= SUM(C4, C5)
= SUM(C5, C5)
= SUM(C6, C5) etc

How do I do this?

Thanks

 

[Andy Brown]

Change C5 to an absolute reference to anchor it -

=SUM(C4,$C$5)

Rgds,
Andy