Cummulative Percentage Change over Multiple Years

[bgaffen]

How can I calculate the cummulative percentage change, for example of 5 years of sales numbers. My manager at a former job had a formula but that was a long time ago.

brian

 

[Juan Pablo González]

Hi, welcome to the board.

Basically, it depends on how your data is set up. But if for example you have the sales going from A2 down, you could use something like

=SUM($A$2:A2)/SUM($A:$A)

formatted as a percentage, and drag it down.

 

[bgaffen]

Cumulative Percentage Change over Multiple Years

1999 2000 2001 2002 2003 2004
$633,223 $600,229 $728,642 $812,296 $643,441 $699,369

This is the way my data looks. I know how to do a change from two consecutive years but let's say the % change form 1999 to 2004. it wouldn't be the change in two numbers but the cumulative change of 5 increases and/or decreases in sales.

i appreciate the help.

 

[Domenic]

Assuming that A1:F2 contains your data, try...

=SUMPRODUCT((B2:F2-A2:E2)/A2:E2)

Hope this helps!