Trying to sum an array, via index and match

Training Stats, Rework, upload.xlsm

On the Time Sheet sheet I need a formula that will sum based on changing variables. Right now I am using the aggregate formula to sum, as later I will utilize more of it's functions. So if I select Total Volume from the drop down menu (formatted grey) in A7, and then in C1 select 2014, C2 select Mesocycle 1, C3 select Wk 3 and C4 select Day 1 the formula will sum the Total Volume values that are in 2014 Mesocycle 1Wk 3 day 1.

My data base contains helper columns that are,
Year/Macrocycle & Mesocycle & Week & Day
Year/Macrocycle & Mesocycle & Week
Year/Macrocycle & Mesocycle
and just Year/Macrocycle

So I wanted to look at sum of Total Volume in 2014, Mesocycle 1, I could just leave the Week and Day selection blank. How would I set that up?

I will be offline for the next couple of days, I will work with the formula and get back to you on it. Thank you.

The sumproduct function seemed to work at first until I started changing around the time values in C1:C4, then it appeared to stop working. I did come up with this though,

Formula:

Please Login or Register  to view this content.

Which was the column designator for the index function. It works to a degree, but falls apart with an NA error if only a year is displayed in C1:C4. I don't understand why.

So far I have come up with the following formulas,

Formula:

Please Login or Register  to view this content.

This is finding the row at which my time criteria starts.

Formula:

Please Login or Register  to view this content.

^ This is returning the value from C1:C4, putting it into the appropriate column, searching down, then returning the value from NL, it is failing to sum the array but is much closer

Formula:

Please Login or Register  to view this content.

^ This is summing an entire Ex_Data_LBS row.

Formula:

Please Login or Register  to view this content.

^ This is summing an entire column.

So far I haven't been able to sum a designated array. I have also stopped trying to sum with the aggregate function as right now I am simply trying to get a formula to work as I want, once I get that working in the aggregate function shouldn't be an issue.

Also, entering the above formulas with Ctrl Shift Enter doesn't change the displayed result.