SUMIF and Indirect help

[mrjjman]

Any help would be appreciated, trying to use an indirect with a sumif formula. Here is the sheet:

Marietta Agents

January

February

March

April

May

June

July

August

September

October

November

December

Current Xfers

James

JT

Chris

Latiesha

Suwanee Agents

Chad

Jessica

Amberly

<colgroup><col style="width: 104px"><col width="64"><col width="64"><col width="71"><col width="43"><col width="31"><col width="34"><col width="29"><col width="46"><col width="70"><col width="52"><col width="66"><col width="66"><col width="83"></colgroup><tbody>
</tbody>

Basically, I'm trying to come up with a formula that will add up the sales of each agent from a sheet that corresponds with the months at the top of the sheet. For example, this is what I have come up with, but its very tedious: =SUMIF(January!A:A,A2,January!F:F) for cell B2, =SUMIF(January!A:A,B2,January!F:F) for cell B3, and so on. What I would like is an indirect so that I can change the January!A:A with "&A1&"!A:A, but i can't seem to get it to work. It's much quicker to change the cell rather than changing the month name.

Thanks!

 

[BlueHornet]

Perhaps this will help:
Sheet3

	B
1	January
2	15

<thead>
</thead><tbody>
</tbody>

Excel 2010

Worksheet Formulas Cell Formula B2 =SUM(INDIRECT("'" & B1 & "'!b:b")) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Mind the spacing and positioning of the " and ' characters. Extra spaces in the wrong places will kill the formula.