Answer:
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.
