» Calculating the Average for Numbers Meeting Specified Criteria
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
We want to calculate the average of all prices in column A that are higher than 200.
Solution:
Use the IF and AVERAGE functions in the following Array formula:
{=AVERAGE(IF(A2:A7>B2,A2:A7))}
Book Store:
Recommended Books:
- Special Edition Using Microsoft Office XP
- Analyzing Markets, Products, and Marketing Plans
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Access Version 2002 Step by Step
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
