Question

In order to average together values that match two different conditions in different ranges, an Excel user should use the _____ function.

Answer 1

The answer to this question is the "SUMIFS" function.

Explanation:

The SUMIFS function is a part of Microsoft Excel. It is used to add the number of multi-criteria cells. This function supports logical operators and wildcards. The main purpose to use this function provides a sum of cells with match multiple criteria. The syntax of this function can be given as:

Syntax:

=SUMIFS (sum_ranges, range_1, criteria_1, [range_2], [criteria_2], ...)

In the above syntax, we use 5 arguments in function that can be defined as:

• The sum_range argument is used to sum of range to be summed.
• The range_1 and range_2 arguments are stands for first and second ranges for evaluating. In which the range_2 can be optional.
• The criteria_1 and criteria_2 is used in range, which are range_1 and range_2.