Microsoft Excel Basic Syntax:
INTRO BONUS CLASS SYNTAX EXPLAIN SUM AVERAGE MAX MIN IF SUMIF AVERAGEIF COUNT | COUNTA | COUNTBLANK COUNTIF Excel ShortCut Keys
PART 1:
PART 2:
AVERAGEIF() Syntax
Download: PDF Notes Excel File
the AVERAGEIF function in excel calculates the average of cells that meet one criteria(condition).
Syntax:
= AVERAGEIF(range,criteria,[average_range])
Parameter:
• range - One or more cells, including numbers or names, arrays, or references.
• criteria(condition) - A number, expression, cell reference, or text.
• [average_range] - (Optional) The cells to average, when omitted, range is used.
Example 1:
