Learn Excel EasyDaily One Lesson

Quiz › Formulas & Functions › SUMIF and COUNTIF

SUMIF and COUNTIF: Excel Quiz

5 quick questions. Pick an answer to see if you are right.

  1. A1:A4 has Pen, Book, Pen, Bag. B1:B4 has 10, 50, 20, 100. What will this formula return?
    =SUMIF(A1:A4,"Pen",B1:B4)
    • A. 20
    • B. 10
    • C. 30
    • D. 180
    Show the answerC — 30. The two Pen rows have 10 and 20. Together: 30.
  2. A1:A4 has Pen, Book, Pen, Bag. What will this formula return?
    =COUNTIF(A1:A4,"Pen")
    • A. 30
    • B. 2
    • C. 4
    • D. 1
    Show the answerB — 2. Pen appears 2 times.
  3. B1:B4 has 10, 50, 20, 100. What will this formula return?
    =SUMIF(B1:B4,">20")
    • A. 2
    • B. 180
    • C. 100
    • D. 150
    Show the answerD — 150. Only 50 and 100 are more than 20. Together: 150.
  4. B1:B4 has 10, 50, 20, 100. What will this formula return?
    =COUNTIF(B1:B4,"<=20")
    • A. 2
    • B. 3
    • C. 1
    • D. 30
    Show the answerA — 2. 10 and 20 are 20 or less: 2 cells.
  5. A1:A4 has Pen, Book, Pen, Bag. B1:B4 has 10, 50, 20, 100. What will this formula return?
    =SUMIF(A1:A4,"Bag",B1:B4)
    • A. 0
    • B. 50
    • C. 100
    • D. 1
    Show the answerC — 100. Only one row is Bag, and its number is 100.

Want to learn this? Read the Formulas & Functions lessons →
← More Formulas & Functions topics · All quiz categories