Module 11 : AVERAGEIF
11.1 AVERAGEIF The AVERAGEIF function in Excel 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. Insert the criteria n...
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.