PC Review


Reply
Thread Tools Rate Thread

Re: Calculating an average of data between two dates

 
 
Stunn
Guest
Posts: n/a
 
      30th Jul 2012
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,COLUMN()-COLUMN($F:$F),0),'Teacher View'!$D$1:$Z$1,"<="&OFFSET(BoundariesTerms!$K$2,COLUMN()-COLUMN($F:$F),0))

Copied across and downward.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating the difference between two dates if two criteria are m Detroit David Microsoft Excel Worksheet Functions 3 23rd Apr 2008 09:45 PM
Calculating average of average Lars Brownie Microsoft Access 3 18th Apr 2008 07:36 PM
Calculating number of days between two dates that fall between two other dates richard.goodger@gmail.com Microsoft Excel Misc 5 26th Oct 2005 06:18 PM
Calculating dates - Need to calculate years and months between source dates. jmw748 Microsoft Access Queries 2 7th Jan 2004 01:31 PM
Showing data between two dates in multiple subreports by enter two dates Martijn Microsoft Access Reports 0 26th Sep 2003 10:37 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:29 AM.