Multiple choice technology

What does the SUMIF function do?

  1. Adds all the numbers in a range of cells.

  2. Adds up cell values based on a condition.

  3. Returns a subtotal in a list or database.

  4. None of the above.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SUMIF adds values that meet a specified condition, unlike SUM which adds all values unconditionally. It requires a range to test, a criteria to match, and an optional range to sum.

Keep practicing — related questions