Sheetnames in formula

F

Frank

I have 3 sheets (named 2001, 2002, 2003 representing
different years) and a sheet named variance. All have
identical row/column headings.

In the sheet variance, I'd like to supply names of two
sheets and calculate the variance between them. I could
create a different sheet for each variance (2003-2002,
2002-2001, 2003-2001) but I don't want to do that.

Any ideas?
 
H

Harald Staff

Hi Frank

With 2002 in A1 and 2003 in A2, this formula sums their cell C7:
=INDIRECT(A1&"!C7")+INDIRECT(A2&"!C7")

HTH. Best wishes Harald
 
Top