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?

January (drop down)	Team X (drop down)	SUM			Team X	Team Y
		20		January	XXXXXXX (20)
a	1			February
b	5
c	7
d	4
e	3

<tbody>
</tbody>

 

[BenGee]

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