In a SUMIF conditional function, what should be the order of terms in the parentheses?

the range whose values should be included in the SUMIF if the condition is met, then the range evaluated for a condition

and then the condition itself

the condition itself, then the range whose values should be included in the SUMIF if the condition is met, and then the

range evaluated for a condition

the range whose values should be included in the SUMIF if the condition is met, then the condition itself and then the

range evaluated for the condition

the range evaluated for a condition, then the condition itself, and then the range whose values should be included in the

SUMIF if the condition is met

Question

Computers & Technology

Kenna

2 November, 12:01

In a SUMIF conditional function, what should be the order of terms in the parentheses?

the range whose values should be included in the SUMIF if the condition is met, then the range evaluated for a condition

and then the condition itself

the condition itself, then the range whose values should be included in the SUMIF if the condition is met, and then the

range evaluated for a condition

the range whose values should be included in the SUMIF if the condition is met, then the condition itself and then the

range evaluated for the condition

the range evaluated for a condition, then the condition itself, and then the range whose values should be included in the

SUMIF if the condition is met

+5

Answers (1)

Know the Answer?

Cristina Drake · Answer 1

the range evaluated for a condition, then the condition itself, and then the range whose values should be included in the SUMIF if the condition is met

Explanation:

SUMIF (range, criteria, [sum_range])

range - the range of cells to be evaluated by your criteria, required.

criteria - the condition that must be met, required.

sum_range - the cells to sum if the condition is met, optional.