» Calculating the Average Difference between List Price and Sale Price
CATEGORY - Excel Array Formulas
VERSION - All Microsoft Excel Versions
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)

Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- The New Financial Order: Risk in the Twenty-First Century
- Windows XP All-in-One Desk Reference For Dummies
- Microsoft Outlook 2002 for Dummies
No comments have been submitted.

