Advance Excel (SumIf & SumIfs)

ADVANCE EXCEL

SUMIF FUNCTION

The 'SumIf' function is used to calculate the sum of only selected values by giving a certain condition.

Syntax: SumIf(Range, Criteria, [Sum_range])

Range: The range is cells address in which formula applies (Ex: A1: A10)

Criteria: This is a real condition, that select the values for sum (Ex: ">60")

[Sum_range]: This is an optional argument.

SumIf Excel Example 1: In this example, we calculate sum the of only those marks which are greater than 60.

SumIf Excel Example 2: In this example, we are calculating the sum of salaries but only for sales department employees.

SUMIFS FUNCTION

The 'SumIfs' function is an extension of 'SumIf' function and it is used to calculate the sum of only selected values by multiple conditions.

Syntax: SumIf(Sum_range, Criteria_range1, Criteria1, ...)

Sum_range: This is a cell address of those values in which want to calculate the sum.

Creteria_range1: This is a criteria value's cell address.

Criteria1: This is a number of criteria which you want to apply in the calculation.

Example: In this example, we are calculating a sum of salary for all the Sales and Purchase department employees.

HOME