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.

« I need Help with a date calculator | Betainv() problem »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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