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...
Request a quote
- We offer a price match guarantee.
- No hassle set-up. Fully branded LMS with single sign-on and API integration.
- Desktop and mobile compatible. Train anywhere, anytime.
Once submitted, a member of our team will be in touch to talk you through your training options.