Sumifs/match/index?

Hi,

I have a table of data that I need to sum up but I am having difficulty figuring it out.

I've tried a combination of SUMIFS, MATCH and INDEX with OFFSETS but haven't been successful. The problem is that there are 2 vertical criteria in the problem.

I have a table made up of teams with date ranges along the top. These date ranges have past dates and future dates. The future dates are then split into 2 separate sections of confirmed and unconfirmed charges. I need to be able to return the sum of each section for each team individually using a lookup of some sort.

I have to use the whole range as a basis as the dates change and the separate ranges vary in size each week.

I've attached an example of my table.

Does anyone have any ideas?

Thanks in advance.