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