monthly average each year

Occasional Visitor


guys please help,


how to calculate monthly average per year 

thanks for your help

3 Replies


Welcome to your Excel discussion space!


If you’re looking to ask a question or start a conversation about Excel, you’re in the right place!  Ask away.


Please include the following info to help others answer your question:


Once you got a good answer to your question, please accept it as solution to help others looking for answer to the same/similar question.


Simplest way is to create PivotTable aggregating on average. 

Create a PivotTable to analyze worksheet data - Office Support (


This solves the issue:




How it works: 

  1. Write first Date of each month for respected years in Column E & apply cell format mmm-yyyy.
  2. Enter this formula in cell F39 & fill down.







  1. Formula returns ZERO for moths, are not available in Column B.


You may use this formula also:







Accept this as Best response as well Like, if my post solves the issue.