Respuesta :

Answer:

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.

ACCESS MORE
EDU ACCESS