Calculating average per month based on month dates

Question

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

In which cell @pnuts? – Dharmesh SurajBali Aug 19 '17 at 00:09 — Dharmesh SurajBali, Aug 19 '17 at 00:09

score 1 · Accepted Answer · answered Aug 17 '17 at 19:18

1

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

answered Aug 17 '17 at 19:18

TheMaster

@Dharmesh SurajBali If the formula works, Mark this as answered – TheMaster Aug 18 '17 at 06:37
Wow! Thanks. That works. However I'm trying to build a monthly table by month name to plot a graph for monthly averages. You can see the whole sheets here: https://docs.google.com/spreadsheets/d/1pX2ntRev4Q1CFthrHcE0BqfRxKtUa78nzCgXsK4kzQs/edit?usp=sharing I want to average weight, muscle mass and fat mass by month and plot them on the graph using a table of averages which I need the formula for. – Dharmesh SurajBali Aug 18 '17 at 13:23
Just like avg(C) in select. Add others too... "Select month (), avg(C),avg(D) , etc etc" – TheMaster Aug 18 '17 at 13:31
Thank you so much for your help. Will try these – Dharmesh SurajBali Aug 18 '17 at 22:22

1 Answers1