|
|
#9
08-08-2012, 07:05 AM
|
||||
|
||||
You've referenced column J for both the Month and the Year criteria. What does column J contain?
Code:
=AVERAGEIFS(SUPPORT!K9:K258,SUPPORT!J9:J258,MONTH( TODAY()),SUPPORT!J9:J258,YEAR(TODAY())) 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Change Resource Time vs. Duration when Updating Work column | lylel | Project | 3 | 07-23-2012 06:09 PM |
| Displaying Work Week instead of date in a column. | whitney07 | Project | 1 | 07-05-2012 02:27 PM |
 definition of work column
|
ketanco | Project | 9 | 05-31-2012 05:15 PM |
|
Right-Aligning Data to a Column
|
sunnyside | Excel | 3 | 02-27-2012 01:25 AM |
| Formula not getting copied to entire column | theacegary | Excel | 1 | 11-29-2010 02:18 PM |
Windows 7 32bit 
Office 2010 32bit
Threaded Mode