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...
Get a quote
- We offer a price match guarantee.
- Set-up is simple, with a fully branded LMS, single sign-on and API integration.
- It works on desktop and mobile, so your team can train wherever suits them.
Once you’ve sent your details, one of our team will be in touch to talk you through your training options.