With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, January 21, 2018
yogi_Compute Average Subject to Specified Criteria For Each Student From Data In Another Sheet
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)