How to Compute Monthly Means in Excel

This is the 3rd video in a multi-part tutorial on how to acquire daily weather data for a specific place, caclulate monthly and annual averages, and calculate heating and cooling degree days. In this video we calculate monthly temperature means using array formulas in Excel.

[@tonysu8286]

Bro your video is such a GOLD! saved my time and energy I was looking this method a lot and found ur video finally thanks a LOT!

[@christinawebber9876]

These tutorials are awesome! I teach HS meteorology and with us going online now, I was looking for ways to teach them how to do the calculations at home. Your videos are really nicely done!

[@obaidullahsalehie9163]

Excellent description. You calculated monthly average for one year. If we want to continue with several years. How to do it in excel?

[@ardentword508]

Lifesaver. I have a lot of annual averages to work out; you've just saved me a lot of time my friend!

[@nataliiabudeniuk2193]

Thank you for really good tutorial. Here you have calculated the avg monthly temp for 2013. Could you tell how to calculate avg monthly for period, for ex.2013-2023? thank you

[@christ0ph3rson70]

Nice thanks man! I’m an analyst at a transportation company and needed a way to calculate average truckload rates by month for like 10000 lines of data.

[@ludwigloffler6437]

Exellent video! You helped me a lot! Thanks for the help and regards from Germany.

[@pbnevan]

Thank you very much! Great video!

[@parvaizahmed3224]

I followed all the steps but the averages calculated are wrong. I don't know how and where to correct myself. I need help in this...!!

[@BichNguyen23391]

Thank you so much! Very useful for me!

[@tamdes4961]

very nice to see you

[@beurself8457]

Thank you for the video !!

[@misumajumder5917]

thank you so much..how to calculate monthly standard deviation of temperature???

[@maktheturd6220]

This is not what I'm interested because it's all the year together for that same month. I have 5 years sample and need it to calculate the average for that month of the year. Help!

[@AdarshSingh07]

what to do for discharge/runoff?

[@munawarali733]

splendid, how we r supposed to treat years along with months

[@aartipoudel7960]

Thank you. helped a lot :)

[@opinions4u]

how to calculate monthly averages for more than 1 year?

[@FadliBKL]

Instead of column A formula:
“month()”, you can make formula=“year()”&”month()”

[@tenacioussahi]

How to do if I have to calculate same for last fifty years. Don't you think it would be too hectic.

[@ludwigloffler6437]

+Avinash Gupta Its the same, I just calculated daily measurements from 1961 to 2014 and it worked perfectly!