J
JHL
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.
=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.