Need help with which function to use

[ShawnGoddard]

I am under a huge deadline and I do not have a clue where to start.

I have a large spreadsheet. Each section is a different project. My columns are dated for each day of a 4 year period of time. Within each project each day is marked active or inactive. Each project has the same items listed. I need to sum each column into a grand total for each item. But only if that day is indicated to be active. The active status will be turned on and off for each day and I need it to sum accordingly.

This spreadsheet is thousands of lines down and hundreds across.

Here is an example of the spreadsheet

Item	2/1/2014	2/2/2014
	Project A	Project B
	Active	Inactive
Gas	1200.00	1200.00
Fluid	100.00	0.00
Sugar	200.00	200.00
	2/1/2014	2/2/2014
	Project B	Project B
	Inactive	Active
Gas	1000.00	1000.00
Fluid	0.00	0.00
Sugar	200.00	200.00

And this is where I am trying to get to.

Total	2/1/2014	2/2/2014
Gas	1200.00	1000.00
Fluid	100.00	0.00
Sugar	200.00	200.00