Math & Trig =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Quiz =SUMIFS — 10 Questions

10 quiz questions about =SUMIFS — test syntax, arguments, examples & errors!

Questions: 10 questions 15 questions Random 10 or 15 questions from the pool + shuffled options each time

← SUMIFS ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

In =SUMIFS, which is argument #3?

Question 2 of 10 2/10

What is the output type of =SUMIFS?

Question 3 of 10 3/10

Which statement about =SUMIFS is correct?

Question 4 of 10 4/10

Which is the correct syntax of =SUMIFS?

Question 5 of 10 5/10

Is argument “criteria1” required in =SUMIFS?

Question 6 of 10 6/10

Which formula is a valid example of =SUMIFS?

Question 7 of 10 7/10

Which use case fits =SUMIFS?

Question 8 of 10 8/10

Since which Excel version is =SUMIFS available?

Question 9 of 10 9/10

What is the type of argument “criteria_range2, criteria2” in =SUMIFS?

Question 10 of 10 10/10

Does =SUMIFS return a dynamic array?

Click a question to see the answer.

1. In =SUMIFS, which is argument #3?

A. criteria1 ✓
B. lookup_value
C. sum_range
D. value

Explanation: Argument #3 is “criteria1”.

2. What is the output type of =SUMIFS?

A. Value
B. Mixed
C. Date
D. Number ✓

Explanation: Output is “Number”.

3. Which statement about =SUMIFS is correct?

A. The result is incorrect when Sum_range has TRUE or FALSE values.: TRUE and FALSE values for Sum_range are evaluated differently, which may cause unexpected results when they're added.Cells in Sum_range that contain TRUE evaluate to 1. Those that contain FALSE evaluate to 0 (zero).
B. Output is always a dynamic array
C. 0 (Zero) is shown instead of the expected result.: Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name. ✓
D. Use wildcard characters.: Using wildcard characters like the question mark (?) and asterisk (*) in criteria1,2 can help you find matches that are similar but not exact.A question mark matches any single character. An asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) in front of the question mark.For example, =SUMIFS(A2:A9, B2:B9, "=A*", C2:C9, "To?") will add all instances with name that begin with "To" and ends with a last letter that could vary.

Explanation: Correct: 0 (Zero) is shown instead of the expected result.: Make sure Criteria1,2 are in quotation marks if you are testing for text values, like a person's name.

4. Which is the correct syntax of =SUMIFS?

A. SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
B. =AVERAGEIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
C. =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...) ✓
D. =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ..., 0)

Explanation: Correct syntax: =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

5. Is argument “criteria1” required in =SUMIFS?

A. No
B. —
C. Yes
D. Yes ✓

Explanation: “criteria1” is required.

6. Which formula is a valid example of =SUMIFS?

A. =SUMIFS(A2:A9, B2:B9, "=A*", C2:C9, "Tom") ✓
B. =SUMIFS(A2:A9, B2:B9, "=A*", C2:C9, "Tom", 0)
C. =AVERAGEIFS(A2:A9, B2:B9, "=A*", C2:C9, "Tom")
D. SUMIFS(A2:A9, B2:B9, "=A*", C2:C9, "Tom")

Explanation: Correct example: =SUMIFS(A2:A9, B2:B9, "=A*", C2:C9, "Tom")

7. Which use case fits =SUMIFS?

A. Daily Tasks ✓
B. Conditional Aggregation
C. Reporting
D. Conditional Logic

Explanation: Use case “Daily Tasks” fits SUMIFS.

8. Since which Excel version is =SUMIFS available?

A. All versions
B. Excel 2007 ✓
C. Excel 2019
D. Excel 2007 (Compatibility)

Explanation: Version: “Excel 2007”.

9. What is the type of argument “criteria_range2, criteria2” in =SUMIFS?

A. Array
B. Text
C. Any type
D. Number ✓

Explanation: Type of “criteria_range2, criteria2” is “Number”.

10. Does =SUMIFS return a dynamic array?

A. No
B. —
C. Yes
D. No ✓

Explanation: SUMIFS does not spill.