Important Spreadsheet Formulas - IF, SUM, SUMIF & SUMIFS

Let’s look into some of the key spreadsheet functions that helps to create meaningful reports

IF

IF checks whether a condition is satisfied or not. The formula return one output if the condition is satisfied and if the condition is not satisfied, it gives another output

Syntax

IF(logical_test, [value_if_true] , [value_if_false"])

SUM

SUM gives the sum of numbers in a range

Syntax

SUM(range)

SUMIF

SUMIF gives the sum of numbers in a range that meets a certain criteria

Syntax

SUMIF([sum_range], [criteria_range], criteria)

• sum_range - This is the range of cells that you want to sum. If not provided, the function will use the same range as the criteria
• criteria_range: This is the range of cells that you want to apply the criteria to.
• criteria: This is the condition that the cells must meet to be included in the sum.

SUMIFS

SUMIF gives the sum of numbers in a range of cells that meets multiple criteria

Syntax

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2],…)

• sum_range: This is the range of cells that you want to sum
• criteria_range1, criteria_range2, etc, These are the ranges of cells that you want to apply the criteria to.
• criteria1, criteria2, etc. These are the conditions that the cells must meet to be included in the sum