Math & Trig =SUMIF(range, criteria, [sum_range])

Quiz =SUMIF — 10 Questions

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

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

← SUMIF ▦ Practice in Playground

Progress — 10 questions 1 of 10

Question 1 of 10 1/10

Which statement about =SUMIF is correct?

Question 2 of 10 2/10

Is argument “criteriaRequired” required in =SUMIF?

Question 3 of 10 3/10

Which category does =SUMIF belong to?

Question 4 of 10 4/10

Which is the correct syntax of =SUMIF?

Question 5 of 10 5/10

Does =SUMIF return a dynamic array?

Question 6 of 10 6/10

In =SUMIF, which is argument #3?

Question 7 of 10 7/10

Is argument “rangeRequired” required in =SUMIF?

Question 8 of 10 8/10

What is the type of argument “sum_rangeOptional” in =SUMIF?

Question 9 of 10 9/10

Is =SUMIF volatile?

Question 10 of 10 10/10

In =SUMIF, which is argument #1?

Click a question to see the answer.

1. Which statement about =SUMIF is correct?

A. Only works in old versions
B. Select entire column for best performance
C. If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function. ✓
D. Output is always a dynamic array

Explanation: Correct: If you want, you can apply the criteria to one range and sum the corresponding values in a different range. For example, the formula =SUMIF(B2:B5, "John", C2:C5) sums only the values in the range C2:C5, where the corresponding cells in the range B2:B5 equal "John." To sum cells based on multiple criteria, see SUMIFS function.

2. Is argument “criteriaRequired” required in =SUMIF?

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

Explanation: “criteriaRequired” is required.

3. Which category does =SUMIF belong to?

A. Math & Trig ✓
B. Lookup & Reference
C. Information
D. Database

Explanation: Category is “Math & Trig”.

4. Which is the correct syntax of =SUMIF?

A. =SUMIF(range, criteria, [sum_range], 0)
B. =SUMIF(range, criteria, [sum_range]) ✓
C. SUMIF(range, criteria, [sum_range])
D. =AVERAGEIF(range, criteria, [sum_range])

Explanation: Correct syntax: =SUMIF(range, criteria, [sum_range])

5. Does =SUMIF return a dynamic array?

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

Explanation: SUMIF does not spill.

6. In =SUMIF, which is argument #3?

A. rangeRequired
B. sum_rangeOptional ✓
C. criteria
D. lookup_value

Explanation: Argument #3 is “sum_rangeOptional”.

7. Is argument “rangeRequired” required in =SUMIF?

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

Explanation: “rangeRequired” is optional.

8. What is the type of argument “sum_rangeOptional” in =SUMIF?

A. Logical
B. Number
C. Date
D. Range ✓

Explanation: Type of “sum_rangeOptional” is “Range”.

9. Is =SUMIF volatile?

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

Explanation: SUMIF is not volatile.

10. In =SUMIF, which is argument #1?

A. lookup_value
B. range
C. value
D. rangeRequired ✓

Explanation: Argument #1 is “rangeRequired”.