In MS Excel, which of the following expressions is a valid syntax structure to calculate a logical conditional sum using multiple column criteria limits simultaneously?
A. =SUM.IF.MULTIPLE(Criteria_Range1, Criteria1, ...)
B. =SUMIFS(Sum_Range, Criteria_Range1, Criteria1, Criteria_Range2, Criteria2)
C. =SUMIF(Criteria_Range, Criteria, Sum_Range)
D. =MULTISUM(Sum_Range, Criteria_List)
Answer: Option B
Solution (By JKSSB Mock Tests)
The SUMIFS function evaluates multiple criteria fields. Its syntax differs from SUMIF because it places the 'Sum_Range' as the very first argument.
No comments yet. Be the first to start the discussion!