Using name tabs in formulas

[mikedharding]

I have a workbook where for each new month I am importing data into a new tab and then using SUMIFS to derive a total by data values. Each tab is named Jan 14, Feb 14 etc. I'd like to have a formula that will go to the right tab and select the data based on the month that is input to a cell e.g. Jan. I'm thinking this may be something to do with the INDIRECT function but can't figure it out.

 

[farmerscott]

Mike,

Welcome to the forum.

Unless you had all 12 monthly sheets in place it would not be possible to reference them all back to a mainsheet (which I assume is what you are doing) using a conventional formula, without adjusting it for each month.

How many cells to you want to add within each sheet?

Are you opposed to VBA? As we could write code that when each sheet is added it then loops thru all sheets and gets your totals.

You could also get some ideas from looking at 'consolidation' in Excel help.

Hope that helps,

FarmerScott