Use INDEX MATCH to return data between dates and get AVERAGE of values in two colums

Hello,

I have a spreadsheet that returns some matching data between two dates from sheet "DATA ENTRY" into "CHARTS" (some columns, not all), but I need it to be able to display the average of the results for columns "U" and "V". Since there are a few rows that have the same shift and "hour" but different dates, I need to combine columns "U" and "V" results (From "DATA ENTRY" columns "K" and "L" for date range selected into an average. I highlighted the rows that should be averaging in yellow and show the average values on the DATA ENTRY sheet as reference. I'm guessing I just need some sort of AVERAGE function, but I'm confused as to where it belongs in the INDEX/MATCH formulas in columns "U" and "V" in the sheet "CHARTS"

Please see example attached.

Machine Data - 7-01-15.xlsb

Copy this into 'Charts' cell U4 and copy down and right.

Formula:

Please Login or Register  to view this content.

That should do the trick.