» New AVERAGE Functions in Excel 2007
CATEGORY - Excel Formula and Function
VERSION - Microsoft Excel 2007
The AVERAGE function expanded, two more functions are added.AVERAGEIF
AVERAGEIFS
The AVERAGEIF Function
A new function is added to SUMIF and COUNTIF criterias functions:
The AVERAGEIF function returns the average (arithmetic mean) of all cells in a range that meet a given criteria.
The AVERAGEIF function, SUMIF function and COUNTIF function are looking for a given criteria in a range of cells and return results according to the type of the function, see examples in the screenshot below.
Book Store:
Recommended Books:
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Advanced modelling in finance using Excel and VBA
- Keys to Reading an Annual Report (Barron's Business Keys)
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
No comments have been submitted.
