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>
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: center"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</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[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]B[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD]January[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD="align: right"]15[/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010

Cell	Formula
B2	=SUM(INDIRECT("'" & B1 & "'!b:b"))

<tbody>
[TD="bgcolor: #FFFFFF"] Worksheet Formulas [TABLE="class: html-maker-worksheet"]
<thead>[TR]

</thead><tbody>
</tbody>

[/TD]
[/TR]
</tbody>[/TABLE]

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