New answers tagged


Please, see Test file Formula in cell C2 (with results in columns C:D) aggregates your data by quarters returning last date of respective quarter and average amount for this quarter. =QUERY( {B2:B, ARRAYFORMULA(eomonth(date(year(EOMONTH(A2:A,0)),(quotient(MONTH(A2:A)-1,3)+1)*3,1),0))}, "Select Col2, AVG(Col1) Where Col1 > 0 Group by Col2 Order by ...

Top 50 recent answers are included