How to calculate average using averageif function, using a few diff data sets in excel 2016

AverageIf in excel will calculate the average of cell values which matches the given condition. It is a mixture of “If” construct and average function. Let us understand this concept with an example.

=AVERAGEIFS(B2:B8, A2:A8, ""orange"", B2:B9, "">100"")

This will check whether A2:A8 has a content “orange” and then pick the associated value if B2:B3 value is >100. So it checks two condition and then calculate the average.

Let us look into one another example:

=AVERAGEIFS(D3:D9, B3:B8, ""<8/22/2015"", C3:C8, ""<>"")

This would get the values less than the specified date provided it is not equal to the values in C2 to C8 cells.

The definition of a function usually is visible to other functions.

Explanation:

In Computer programming, a function can be defined as a group of organized, reusable sets of code that is used to perform a specific task i.e a single but related action. Thus, a function accepts data as an input, process the data and return a single result or a set of results.

A parameter can be defined as a value that can be passed to a function. This value can be passed to a function either by reference or by value.

This ultimately implies that, parameter variable stores information which is passed from the location of the method call directly to the method that is called by the program.

Basically, parameters can serve as a model for a function; when used as an input, such as for passing a value to a function and when used as an output, such as for retrieving a value from the same function.

Hence, when you create classes or variables in a function, you can can set the values for their parameters.

Furthermore, the true statements about a function includes;

I. A function define specific tasks that reusable at many points in a program.

II. The name and arguments of the function must be specified by a function.

III. The implementation of a function is generally hidden from the caller.