Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

This question already has an answer here:

I have a workbook containing monthly data sheets (sheet 1="January", sheet 2="February", etc.). I also have a "Data Display" sheet where I have endusers select the months summary they would like to see. I'm using a data validation box for user to choose the month. Based upon the end user's selection, I want to have my formula adjust this formula to the appropriate sheet:

=SUMIF(January!$Q:$Q,"Total_Controllable_Expenses",January!$S:$S)

All of my monthly sheets have the same column assignments.

share|improve this question

marked as duplicate by Scott, KronoS, 8088, Windos, CharlieRB Mar 29 '13 at 19:38

This question was marked as an exact duplicate of an existing question.

Turn the fixed reference January into reference to your validated choice (say in A1). Then wrap in an INDIRECT. ie replace both instances of January with INDIRECT(A1&" and in each case match off (ie close to suit) the quotes and parentheses.

=SUMIF(INDIRECT(A1&"!$Q:$Q"),"Total_Controllable_Expenses",INDIRECT(A1&"!$S:$S"))
share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.