Which function would you use to compute the sum of numbers that meet a condition across a range?

• A. SUM
• B. AVERAGE
• C. SUMIF
• D. MIN

Answer: (C)

When you need to add only the numbers that meet a condition in a range, use a conditional sum function. This type of function is built to scan a range for values that satisfy a criterion and then sum those corresponding values. The common form is SUMIF(range, criteria, [sum_range]). If you provide just the range and criteria, it sums the values in that same range that meet the condition. If you provide a separate sum_range, it sums those values where the condition is true in the test range. For example, to sum all numbers in A1:A10 that are over 100, use SUMIF(A1:A10, ">100"). To sum corresponding values in B1:B10 where A1:A10 > 100, use SUMIF(A1:A10, ">100", B1:B10). Other functions like AVERAGE compute averages, not sums, and MIN returns the smallest value, not a sum. So SUMIF is the function designed for summing with a condition.