Module 14 : AVERAGEIF
14.1 AVERAGEIF The AVERAGEIF function is similar to the AVERAGE function in that it calculates the arithmetic mean of a set of values, only of values that meet certain criteria.For example, you can specify that it should only take into account values greater than 30 or 100. The formula for the AVERAGEIF function is: =AVERAGEIF(range, criteria, [average_range]) The range should refer to the range of cells you want to be included in the calculation. The criteria should be in parentheses. T...
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.