Google Sheets Course: Functions

There are several hundred more or less complex functions in Google Sheets, some of which will be very useful to you.


Insert a Function

To insert a function, enter a = then the first letter(s) of the function to display suggestions, and press Enter to validate your choice:

google sheets add function functions

In the case of the SUM function, select the range of cells for which you want to get the sum and validate:

google sheets function sum functions

To choose a function from a list, click on in the toolbar or on "Function" in the Insert menu:

google sheets list functions png

You will notice that a short description is displayed when hovering over functions.

In the case of the AVERAGE function, also select the range of cells for which you want to get the average and validate:

google sheets function average functions

More Functions

You will find explanations and examples of usage for the most common functions on the page dedicated to functions (accessible via the "Functions" link in the top menu).