A logical function that adds the values in cells that meet specific criteria in multiple ranges.
A)COUNTIF
B)COUNTIFS
C)SUMIF
D)SUMIFS

Question

Quizplus · Accepted Answer

SUMIFS is the logical function that adds the values in cells based on multiple criteria in different ranges. This function is used when you want to sum the values based on the combination of conditions. For example, to sum the sales for a particular product in a specific region, you need to use SUMIFS.

A Logical Function That Adds the Values in Cells That