Which function adds numbers in a range only if they meet a specified condition?

• A. SUMIF
• B. SUMIFS
• C. COUNTIF
• D. AVERAGEIF

Answer: (A)

Conditional summing uses a function that adds numbers only when they satisfy a given condition. The best choice here is SUMIF. It checks each value in a range against a criterion and sums those that meet it. If you want to sum values in the same range that meet the condition, you can simply use SUMIF(range, criterion). If the numbers to sum are in a different range than the ones you’re testing, you can provide a third argument to specify that sum range, like SUMIF(range, criterion, sum_range). For example, SUMIF(A1:A10, ">5") adds all values in A1:A10 that are greater than 5. If you need to sum based on a condition in one range but sum values from another, you’d use SUMIF(A1:A10, ">5", B1:B10). The other functions do different tasks: SUMIFS handles multiple conditions, COUNTIF counts how many cells meet a condition, and AVERAGEIF returns the average of values that meet a condition.