I have a problem that I have been unable to solve, or find a result that works for me.

I have a sheet with data entered from a lab. The dates are based on sampling time, and each sample point is sampled on different frequencies. Ex:

Sample A 1/1/2014 13:03 (Different column, "/c" in future) 6.2 /C Sample B 1/1/2014 16:43 /C 7.2 (and so on for about 50 samples)

I will have hundreds of these results in a sheet, and I need to make a summary that can lookup for a month and year I enter, and return the average of all those results for that entered month. I have been successful doing this when the time is not a factor, using lookup and match functions, but unsuccessful when the time changes.

I've tried using Month functions, but haven't figured out how to extract the dates that match the month.

Any ideas? I have a decent Excel knowledge but this one is stumping me.