Sumif range?

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.
 
C

caroline

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

JHL

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top