| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating an average of data between two dates
Assuming that you want the results in 'Summary View'!F4:L33 and that the student order will always be the same in both sheets, try this in 'Summary View'!F4
=AVERAGEIFS('Teacher View'!$D5:$Z5,'Teacher View'!$D$1:$Z$1,"="&OFFSET(BoundariesTerms!$J$2,C OLUMN()-COLUMN($F:$F),0),'Teacher View'!$D$1:$Z$1,"<="&OFFSET(BoundariesTerms!$K$2,C OLUMN()-COLUMN($F:$F),0)) Copied across and downward. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating hourly average from large data set | Excel Discussion (Misc queries) | |||
| How do I ignore "#N/A" data in a column while calculating average | Excel Worksheet Functions | |||
| Calculating Average | Excel Discussion (Misc queries) | |||
| calculating average on bottom 50% of data | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Threaded Mode
