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

Quiz =SUMIF — 15 Questions

15 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 — 15 questions 1 of 15

Question 1 of 15 1/15

Which function is NOT related to =SUMIF?

Question 2 of 15 2/15

In =SUMIF, which is argument #2?

Question 3 of 15 3/15

Does =SUMIF return a dynamic array?

Question 4 of 15 4/15

Which statement about =SUMIF is correct?

Question 5 of 15 5/15

Which use case fits =SUMIF?

Question 6 of 15 6/15

How many required arguments does =SUMIF have?

Question 7 of 15 7/15

In =SUMIF, which is argument #3?

Question 8 of 15 8/15

Is argument “criteriaRequired” required in =SUMIF?

Question 9 of 15 9/15

Which category does =SUMIF belong to?

Question 10 of 15 10/15

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

Question 11 of 15 11/15

Which function is related to =SUMIF?

Question 12 of 15 12/15

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

Question 13 of 15 13/15

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

Question 14 of 15 14/15

How many optional arguments does =SUMIF have?

Question 15 of 15 15/15

Is argument “rangeRequired” required in =SUMIF?

Click a question to see the answer.

1. Which function is NOT related to =SUMIF?

A. SUM
B. AVERAGEIF
C. FDIST ✓
D. COUNTIF

Explanation: “FDIST” is not related to SUMIF.

2. In =SUMIF, which is argument #2?

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

Explanation: Argument #2 is “criteriaRequired”.

3. Does =SUMIF return a dynamic array?

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

Explanation: SUMIF does not spill.

4. Which statement about =SUMIF is correct?

A. Only works in old versions
B. Text is always ignored
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. Volatile and recalculates every time

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.

5. Which use case fits =SUMIF?

A. Rounding & Numeric
B. Daily Tasks ✓
C. Reporting
D. Data Cleaning

Explanation: Use case “Daily Tasks” fits SUMIF.

6. How many required arguments does =SUMIF have?

A. 1 ✓
B. 0
C. 3
D. 2

Explanation: =SUMIF has 1 required, 2 optional (3 total).

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

A. criteria
B. criteriaRequired
C. sum_rangeOptional ✓
D. range

Explanation: Argument #3 is “sum_rangeOptional”.

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

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

Explanation: “criteriaRequired” is required.

9. Which category does =SUMIF belong to?

A. Database
B. Math & Trig ✓
C. Engineering
D. Statistical

Explanation: Category is “Math & Trig”.

10. What is the type of argument “rangeRequired” in =SUMIF?

A. Reference
B. Number
C. Date ✓
D. Array

Explanation: Type of “rangeRequired” is “Date”.

11. Which function is related to =SUMIF?

A. AVERAGEIF ✓
B. DECIMAL
C. IMPORTCSV
D. CONCAT

Explanation: “AVERAGEIF” is related to SUMIF.

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

A. Reference
B. Date
C. Mixed
D. Range ✓

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

13. What is the type of argument “criteriaRequired” in =SUMIF?

A. Value
B. Range
C. Text ✓
D. Date

Explanation: Type of “criteriaRequired” is “Text”.

14. How many optional arguments does =SUMIF have?

A. 1
B. 3
C. 2 ✓
D. 4

Explanation: =SUMIF has 1 required, 2 optional (3 total).

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

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

Explanation: “rangeRequired” is optional.