Sunday, January 21, 2018

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
Query by date, average, order by student, with one result per student

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

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!!