Blogging Post Nr.3 by Astrid Corbacho, Lisette habig and Britta Ensinck

Functions:

A function is a preset formula in Excel and Google Spreadsheets that is in charge of carrying out different calculations in the cell in which it is located.

Function Syntax:

“A function's syntax is a layout or structure of the function.”

It incorporates the function's name, brackets, comma separators, and arguments.

This picture is related to the audio and shows the structure of a spreadsheet

COUNT:

The COUNT Function is used to count cells, in which numbers are located. This result represents the count of numbers.

The Syntax of the COUNT Function is:

=COUNT (value1, [value2],...)

• value1 - An item, cell reference, or range.(WHERE TO LOOK FOR, WHAT TO LOOK FOR)

• value2 - [optional] An item, cell reference, or range.

This is the Syntax function of COUNTIFS

COUNTA:

The COUNTA Function is used to count the cells in which data (numbers, dates, letters) is located. This result represents the count of numbers.

The Syntax of the COUNTA Function is:

=COUNTA(value1, [value2], ...)

• value1: The cells that you want to count.
• value2, ....:  It is optional.

COUNTBLANK:

The COUNTBLANK function is used to count blank cells (cells without any data). This result represents the count of numbers.

The Syntax of the COUNTBLANK function is:

=COUNTBLANK(range)