Taking total from adjustable table

[Headline31]

I have a table that has a monthly drop down list and a team list. I have been able to figure out how to make the data change based on those 2 factors using an IF(AND) formula, however I am needing the data to locate to a different cell (XXXXXXX) as well but NOT change. Is it possible to take the sum of January/Team X and move it to the second table and not have it change based on the first table?

[TABLE="class: grid, width: 800, align: left"]
<tbody>[TR]
[TD]January (drop down)
[/TD]
[TD]Team X (drop down)
[/TD]
[TD]SUM
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Team X
[/TD]
[TD]Team Y
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]20
[/TD]
[TD][/TD]
[TD]January
[/TD]
[TD]XXXXXXX (20)
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]a
[/TD]
[TD]1
[/TD]
[TD][/TD]
[TD][/TD]
[TD]February
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]b
[/TD]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]c
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]d
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]e
[/TD]
[TD]3
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[BenGee]

Could you just do a sumif formula direct from the source data? Rather than from the conditional table you've got?