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.