|
|
#1
10-21-2014, 06:33 AM
|
|||
|
|||
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! 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 formula for monthly sum
|
paulys | Excel | 1 | 08-23-2014 09:44 AM |
| How do I keep graph sizing and location for reuse on a monthly basis | lynchbro | PowerPoint | 0 | 06-09-2014 08:06 AM |
| No monthly view | letitbe | Outlook | 1 | 09-05-2013 10:25 AM |
| manipulating borders of a table on a per-border basis | gib65 | Word | 3 | 05-21-2012 12:40 AM |
|
Activating Signature on an ad hoc basis
|
HowardC | Outlook | 2 | 03-13-2012 09:20 AM |
Windows 8 
Office 2010 64bit
Threaded Mode