TRY
=SUMIF(INDIRECT("'" & $B5 & "'!E:E",TRUE),summary!$C$1,INDIRECT("'" & $B5 &
"'!B:B",TRUE))
--
caroline


"JHL" wrote:

I have the following Sumif formula, which works fine.

=SUMIF('South Central'!E:E,summary!$C$1,'South Central'!B:B)


Is it possible to reference a cell that has South Central typed and the
formula use the sheet name and still work properly? I have a large
spreadsheet with numerous sheets to summarize. Referencing a cell for the
sheet names I could copy the formula rather than having to type all the
individual sheet names.

Any help is appreciated.