AVERAGE(...)
Calculate percentage difference for two column
Used Functions
Category: Statistical
Returns the average of its arguments
Syntax
AVERAGE(number1, [number2], ...)
Category: Statistical
Returns the average of its arguments
AVERAGE(number1, [number2], ...)
Practice AVERAGE Formula at Sheetzoom
AVERAGE formula at Microsoft help
0
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.