yogi_Compute Average Subject to Specified Criteria For Each Student From Data In Another Sheet

Google Spreadsheet   Post  #2349

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Jan-21-2018

question by: Mark Engler

https://productforums.google.com/forum/#!topic/docs/GOxENbalfmA;context-place=forum/docs

Query by date, average, order by student, with one result per student
Hello,

I have this spreadsheet set up to import form responses that show student performance over a date range:

https://docs.google.com/spreadsheets/d/17DJzBv62r8ADU1qpzZyK5vaW1IjfRmh2f8ZfWgyJC3U/edit#gid=1636722914

I am trying to set up the sheet so that the "Query" tab pulls information from the "Progress" tab, providing one result per student/goal, and their average performance over a date range, based on a cell value (G1), using this formula:

=QUERY(Progress!B:E,"select B,C,D,E avg(E) > date '"&TEXT(G1,"yyyy-mm-dd")&"' order by B desc", 0)

Any help is greatly appreciated!!

Best,

M