View Single Post
 
Old 10-21-2014, 06:33 AM
lynchbro lynchbro is offline Windows 8 Office 2010 64bit
Advanced Beginner
 
Join Date: Jun 2014
Location: New York
Posts: 41
lynchbro is on a distinguished road
Default Average Times on a monthly basis

In column A I have a list of all days for the year of 2014, formatted as "Tuesday, October 21, 2014". Then I have a table of the months in 2014, formatted at "October". How can I pull the average times for each of those months based on the two formats above?
I assume it is some sort of nested IF statement with a VLOOKUP, but I cannot get it to work? Any ideas?

Here is what my table looks like:

A2=October B2=the average time
The date ranges begin in column A starting at A8 and going down. The times completed are in column B starting at B8 and going down.

Thank you!
Reply With Quote