Google sheets function reference

There are many useful functions available in Google sheets. Learning even just a few of these can save many hours of time. The following is a list of some of the more-useful functions for which we have created tutorials for. For a full function reference for all available functions, see Google Sheets function list.

Function Description Syntax Example usage Tutorials using this function
COUNTIF

Returns a conditional count across a range

COUNTIF(range, criterion)
=COUNTIF(A1:A10, "=Apple")
How to count the number of cells in a range with a specific value in Google sheets
GOOGLEFINANCE

Fetches current or historical securities information from Google

GOOGLEFINANCE(ticker, [attribute], [start_date], [end_date|num_days], [interval])
How to track stock prices in Google sheets
GOOGLETRANSLATE

Translates text from one language into another

GOOGLETRANSLATE(text, [source_language], [target_language])
=GOOGLETRANSLATE(A2, "EN", "ES")
How to translate text with Google sheets
IMAGE

Inserts an image into a cell

IMAGE(url, [mode], [height], [width])
=IMAGE("https://via.placeholder.com/150")
How to create a QR code with Google sheets
IMAGE

Inserts an image into a cell

IMAGE(url, [mode], [height], [width])
=IMAGE("https://via.placeholder.com/150")
How to add images to Google sheets
NOW

Returns the current date and time as a date value

NOW()
How to display the current date and time in Google sheets
TODAY

Returns the current date as a date value

TODAY()
How to display the current date and time in Google sheets