Now I'm trying to use a row number in a formula so I don't have to type the
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