SUMIFS including a cell reference

[mattyblueice]

I am trying to put together a monthly report where I want the SUMIFS to pull in Monthly Budget data based on the month selected.

In cell A2 I have a data validation drop down list with selections from Jan to Dec. In cell A3, I have a Vlookup that looks up the selection in A2 and based on the selection it will reference columns in the Plan sheet. For example, Jan in A2, will reference 'Plan'!$A$5$:$A$75, Feb will reference 'Plan'!$B$5$:$B$75, Mar will reference 'Plan'!$C$5$:$C$75 - these are the Sum Ranges.

In the SUMIFS formula, when I reference A2 to bring in the Sum Range, I can't get the formula to work.

Any suggestions on how to get this to work?

Thanks!

 

[Joe4]

If you are trying to build your range reference via formula, use the INDIRECT function.
See: http://www.contextures.com/xlFunctions05.html

 

[mattyblueice]

Awesome! That worked Joe! Thanks and TGIF