Formula for summing on multiple row criteria and a dynamic column criteria

[ianswilson815]

Hey everyone,
So I am running into a problem with calculating a sum based on 2 row criteria as well as a column criteria which will change dynamically based on say an assumptions tab. The numbers are on a monthly basis, which means I want the range that it is summing from to change based on whatever month is entered to the assumptions page.
I have attached a quick mock up of what the data and how it would look.

Any clues as to what formula would be able to do this?

Thanks

[Jonmo1]

Try this

=SUMIFS(INDEX($C$2:$N$29,0,MATCH(S1,$C$1:$N$1)),$A$2:$A$29,S2,$B$2:$B$29,S3)

S1 is the month you want to sum
Make sure it's entered as a real date, like 6/1/2016. ANY date within the month you want to sum.

S2 = Criteria for column A
S3 = Criteria for column B