Easy Way To Averageif function in Excel

1 year ago
5

This Function is used to find out averagesales of a sales
The AVERAGEIFS function is a premade function in Excel, which calculates the average of a range based on one or more true or false condition.
It is typed =AVERAGEIFS:
=AVERAGEIFS(average_range, criteria_range1, criteria1, ...)
The conditions are referred to as critera1, criteria2, .. and so on, which can check things like:

If a number is greater than another number >
If a number is smaller than another number <
If a number or text is equal to something =
The criteria_range1, criteria_range2, and so on, are the ranges where the function check for the conditions.

The average_range is the range where the function calculates the average.

Loading comments...