C

#### Chris

same formula individually on each row 12 times!

My formula is currently this

=SUM(INDIRECT("'"&'Control Sheet'!$F$57&"'!G7")+INDIRECT("'"&'Control

Sheet'!$F$58&"'!G7")+INDIRECT("'"&'Control

Sheet'!$F$59&"'!G7")+INDIRECT("'"&'Control

Sheet'!$F$60&"'!G7")+INDIRECT("'"&'Control

Sheet'!$F$61&"'!G7")+INDIRECT("'"&'Control

Sheet'!$F$62&"'!G7")+INDIRECT("'"&'Control

Sheet'!$F$63&"'!G7")+INDIRECT("'"&'Control Sheet'!$F$64&"'!G7"))

The formula pulls the value of one cell in each worksheet and totals them.

I normal just drag the formula across and down and it will change G7 to H7

across, G7 to G8 down and so on, but now that I've added the INDIRECT

function dragging doesn't work.

I am thinking that I could change the location of the cell G7 to G(row

number) where row number is the same as the row I am entering the formula

in.

If I can do this with row number, is it possible with column letter and what

if column letter would not always be the same as the column I am in?

Thanks as always

Chris