» 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:
- Mastering Excel 2000 (for beginner)
- Analysis of Financial Statements
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Getting to Yes: Negotiating Agreement Without Giving In
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
No comments have been submitted.
