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.

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.

Thanks caroline. That worked perferctly. I had to change the $B5 to my
actual sheet reference.
I have another question, please? I want to qualify a date in this same
formula.

On sheet were the sumif is written I have a date in cell F1. That date
corresponds to the date column that we are referencing in $B5. If I want to
look for specific dates or a range of dates, how would that be coded in this
sumif?

Thanks so much, and that would be the end of it - I promise.


"caroline" wrote:

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.