Percentage change
Posted by Craig on November 28, 2000 12:05 PM
Is there a quick function that do sum of percentage change of an array (instead of using B1/A1-1 and copy the formula down the column and sum them up in a new cell)?
Posted by Tim Francis-Wright on November 28, 2000 8:25 PM
You can use an array formula to do this.
Remember to use control-shift-enter instead
of just enter when typing it into the correct cell:
=SUM(B1:B10/A1:A10-1)
(change the ranges, of course, to fit your needs).
