4 Replies Latest reply on Sep 21, 2012 5:31 AM by Paul Hare

    Calculate average annual % change?

    Paul Hare

      I have yearly sums of costs and can calculate the % change from one year to the next, but how do I create the overall average annual % change? 

       

      2008 $2008 % change2009 $2009 % changeTotal Avg $Avg. Annual % change
      ...1005.012525.095???????






       

      Grand totals in the attached worksheet averages the costs but does not average the annual percent change.  How do I do that?