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 |
|
|
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 |
|
How to track stock prices in Google sheets | |
GOOGLETRANSLATE | Translates text from one language into another |
|
|
How to translate text with Google sheets |
IMAGE | Inserts an image into a cell |
|
|
How to create a QR code with Google sheets |
IMAGE | Inserts an image into a cell |
|
|
How to add images to Google sheets |
NOW | Returns the current date and time as a date value |
|
How to display the current date and time in Google sheets | |
TODAY | Returns the current date as a date value |
|
How to display the current date and time in Google sheets |