Search code examples
google-sheetsgoogle-sheets-query

Calculating average per month based on month dates


Using the following dataset how can I average weight for each month based on column A for dates in the format month | average weight?

dataset


Solution

  •   =QUERY(A2:C100,"select month(A)+1,avg(C) group by month(A)+1  label month(A)+1 'MONTH',avg(C) 'Average of Weight'")