» Calculating the Average Difference between List Price and Sale Price

Problem:

Column A contains the list prices for a range of items. Their matching sale prices are shown in column B.
We want to calculate the average of the differences between the list and sale price and average difference in percentage.

Solution 1:

To calculate the average difference in dollar amount, use the AVERAGE function in the following Array Formula:
{=AVERAGE(A2:A5-B2:B5)}

Solution 2:

To calculate the average difference in dollar amount, use the SUM and COUNT functions in the following formula:
=(SUM(A2:A5)-SUM(B2:B5))/COUNT(A2:A5)

Screenshot // Calculating the Average Difference between List Price and Sale Price