Fill handle to fill across to the right

[paulwelburn]

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:

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

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.

[SamuelT]

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

[paulwelburn]

Thanx 4 the reply. I've tried this before but the column and cell number remain static! Does this have anything to do with me using the Mac version 11.3.7 2004? The code below works great if I fill down to the next cell but has no effect when filling to the cell adjacent to the right.