Staff Skills academy+
Home » Courses » Microsoft Excel Intermediate Certification » Module 12 : AVERAGEIFS Function
Module 12 : AVERAGEIFS Function
12.1 AVERAGEIFS Function in Excel The AVERAGEIFS function is similar to the AVERAGE function in that it returns the arithmetic mean of a particular set of numbers. The difference is that it will only include numbers that meet multiple criteria. The formula for AverageIFS is the following:=AVERAGEIFS(average_range,criteria_range1, criteria1, [criteria_range2, criteria 2]. The average range is the cells you want to be taken into account for the analysis. The criteria_range is where y...
Lessons
- Module 1: SumProduct Formula
- Module 2 : Data Validation With Date
- Module 3 : Data Validation with Whole Numbers
- Module 4 : Data Validation with List Feature
- Module 5 : ABS Function
- Module 6 : CHAR Function
- Module 7 : CLEAN Function
- Module 8 : CODE Function
- Module 9 : EXACT Function
- Module 10 : AVERAGEA Function
- Module 11 : AVERAGEIF
- Module 12 : AVERAGEIFS Function
- Module 13 : CELL Function With 10 Variations
- Module 14 : LARGE Function
- Module 15: MAX Function
- Module 16: MEDIAN Function
- Module 17: MIN Function
- Module 18: MODE Function
- Module 19 : N Function
- Module 20 : RANDBETWEEN Function (Insert Random Numbers)
- Module 21 : RANK Function
- Module 22 : Remove Duplicate Values
- Module 23 : ROUND Function Up/Down
- Module 24 : Add Custom Background Image
- Module 25: Change Text To Lower Case
- Module 26: Change Text To Upper Case
- Module 27: Change Text To Proper Case
- Module 28: Insert Special Character
- Module 29: Use Autofill : A Time Saving Trick
- Module 30: Treemap Chart
- Module 31: Sunburst Chart
- Module 32: Use Tables
- Module 33: Use Templates
- Module 34: Use Themes
