I am getting this error on my query. Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC I don't understand whats the problem is
Master Data Group-Value pairs 1 | 1 1 | 2 1 | 3 2 | 5 2 | 8 3 | 10 3 | 12 Work Data Group-Value pairs + desired result 1 | 4 | 3 (3≤4, max in group 1)
On sheets, I'm using this formula to sum hours to a specific month from a drop-down menu. =QUERY('Form responses 1'!H2:L, "Select L, Sum(K) WHERE L is not NUL