Fill handle to fill across to the right

I want to use the fill handle to fill across to the right. How do I keep the Column Number with just the cell number incrementing? See code below:

Please Login or Register  to view this content.

When I drag to the right the fill increments the Column from 'C' to 'D' when it's the number I want to increment.
I'm sure there is a simple solution to it.

Hi,

This should do it:

=SUM('08.12.06 TOTALS'!$C19,'15.12.06 TOTALS'!$C19,'22.12.06 TOTALS'!$C19,'29.12.06 TOTALS'!$C19)

To achieve this, click over your cell reference and hit F4. It'll first create an absolute reference $C$19 - this means it'll only ever reference this particular cell wherever you drag the formula. Hit F4 again amd you'll get C$19 - this means that the row referenced will always be 19, but the column will change. Hit it one more time and you get $C19 (which is the one you want) - this keeps the column (C) constant, but allows the row number to change.

HTH,

SamuelT