» Calculating an Average, Only Including Prices on Which There Was no Discount
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
Calculating the average of the prices from column B, but only including those on which there was no discount (as shown in column A).
Solution 1:
Use the AVERAGE and IF functions as shown in the following Array Formula:
{=AVERAGE(IF(A2:A6="No",B2:B6))}
To apply Array formula:
Select the cell, press
Solution 2:
Use the SUMIF and COUNTIF functions as shown in the following formula:
=SUMIF(A2:A6,"No",B2:B6)/COUNTIF(A2:A6,"No")

Book Store:
Recommended Books:
- Windows XP Annoyances
- Excel 2002 Power Programming with VBA
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Personal Finance for Dummies
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.

