Multiple choice technology

What does the SUMIF function do?

  1. Adds up cell values based on a condition.

  2. Adds all the numbers in a range of cells

  3. Returns a subtotal in a list or database

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

SUMIF adds values in a range that meet a specified condition. For example, SUMIF(A1:A10,'>100') adds only values greater than 100, or SUMIF(B1:B10,'Sales',C1:C10) adds values in column C where column B contains 'Sales'. It's different from SUM which adds all numbers without conditions, and SUBTOTAL which creates filtered totals.

Keep practicing — related questions