formula help

[Mike Kiekover]

The following formula queries and totals information on a specified sheet.
In this case the specified sheet name is 2003
I have several sheets (2001, 2002, 2003, 2004.....)
I would like to have the value for the sheet name in the formula reference a
cell in which I could type in the name of the sheet I want to query.

Can someone tell me how to accomplish this. Just changing the '2003' in the
formula to the reference cell doesn't work. (FYI - the reference cell will
be L1)

=SUMIF(('2003'!H2:I400),+(H3),('2003'!D2:I400))

TIA
Mike

 

[Bob Phillips]

=SUMIF((INDIRECT("'"&A1&"'!H2:I400")),(H3),(INDIRECT("'"&A1&"'!D2:I400")))


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Mike Kiekover]

BEAUTIFUL - Thanks Bob

=SUMIF((INDIRECT("'"&A1&"'!H2:I400")),(H3),(INDIRECT("'"&A1&"'!D2:I400")))


--

HTH

RP
(remove nothere from the email address if mailing direct)