» 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:
- Microsoft Office XP Step-By-Step (With CD-ROM)
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Wall Street Journal Guide to Understanding Money and Investing
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Word 2002: The Complete Reference
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
