5 Replies Latest reply on Jan 23, 2019 5:19 PM by Zhouyi Zhang

    How to calculate monthly average?

    Penn Wang

      Hi everyone,

       

      I have a data source that looks like this. I have pivoted the last 5 columns. What I want to do is to calculate the average monthly figures by each column. The SUM function is working okay, but not the AVG function, which gives me 3.2 instead of around 18.

      SUM:

      AVG:

       

      The reason is likely because I only have monthly data before July 2015. And the data changes to daily after July 2015. How should I correct the AVG?

       

      I have attached the workbook. Thank you!