# Is there an excel formula for compound average rate?

by katg703 on January 17, 2012Q: Is there an excel formula for compound average rate?

example:

2009 – $25,000

2010 – $32,000

2011- $36,000

what is the compound average rate for the 3 years?

Q: Is there an excel formula for compound average rate?

example:

2009 – $25,000

2010 – $32,000

2011- $36,000

what is the compound average rate for the 3 years?

I am not sure if you mean “compound average” or just “average”. I am not sure what the “compound average” would even mean in this case to be honest.

To get the average you would just do =SUM(A1:A3)/COUNT(A1:A3) which just translates into adding up the 3 cells and then dividing by the count of the 3 cells (or you could just divide by 3 since you know the number of cells).

matt (Geek) says: on January 17, 2012 at 8:24 am