Blogging Post Nr. 4 by Astrid Corbacho, Lisette Habig and Britta Ensinck

FUNCTIONS:

Spreadsheet has different kinds of functions. These are used to calculate numbers on a table. Here are a few examples of functions:

 

SUMIF

"You use the function SUMIF, when you need to specify the numbers that you want to add together in a column/row."

With the sumif and sumifs functions you add numbers together.

For instance, imagine that in a column that contains numbers, you only want to sum the values that are smaller than 10. To calculate that, for example, you need to use this formula:=SUMIF(A2:A48,"<10")

The syntax for SUMIF is:

SUMIF(range, criteria, [sum_range])

SUMIFS:

The sumifs function is a mathematical function that is used to sum numbers in a table.

Syntax: SUMIFS: (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2].

MEAINING OF THE FUNCTION:

• sum_range: (obligatory)The range of cells you are wanting to add together.
• criteria_range1(obligatory): The column/row of the table where you want a specific kind of data from (Where to look for).
• criteria1: The specific data you are looking for in a table (what to look for).
• [criteria_range2,criteria2](optional):Same as “criteria_range1” and “criteria1”. You can add this, if you have more information to calculate with.