SUMIFS with a dynamic SUM range

[ac123]

Hi, I'm trying to prepare a reporting tool that will let me see cost and head count sortable by time period.

I can do a countifs or sumifs function easily enough sorting by Division/location/role (columns A-C) if I target the formula to a particular date column. However, I want to be able to change the sum/count range by just changing the date field, and have the sum range pick up and adjust to the date field.

Essentially, how do I do a sumifs function so that the column picked up in the SUM range (columns D-I in example below) changes according to the month I select?

Any help appreciated

	A	B	C	D	E	F	G	H	I
1	Division	Location	Role	Jan	Feb	Mar	Apr	May	Jun
2	Production	USA	Dev	2000	2000	2000	0	0	0
3	Production	USA	Testing	0	1000	1000	1000	0	0
4	Production	EU	Dev	3000	3000	3000	3000	3000	3000
5	Production	EU	Testing	1500	1500	1500	0	0	0
6	Sales and Mkting	USA	Sales	2000	2000	2000	2000	2000	2000
7	Sales and Mkting	USA	Mkting	0	0	2000	2000	2000	2000
8	Management	USA	CEO	4000	4000	4000	4000	4000	4000
9	Management	USA	Finance	2000	2000	2000	2000	2000	2000

<tbody>
</tbody>