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