Please enable JavaScript to view the comments powered by Disqus.


AVERAGE(...(...B2:B20-A2:A20)/A2:A20)

Calculate percentage difference for two column

The formula is an array formula that takes difference between corresponding values and then divides the difference with the values in the old column to get the percentages, later it averages (or sums) according to the requirement. 


Used Functions

Category: Statistical

Returns the average of its arguments

Syntax

AVERAGE(number1, [number2], ...)

Lets chat on this