Add formulas & functions Want advanced Google Workspace features for your business? Try Google Workspace today! You can use functions and formulas to automate calculations in Google Sheets. …

On your Android phone or tablet, open a spreadsheet in the Google Sheets app. Tap the cell where you want to add the formula. To pick from a list of functions, tap Function . Then choose a category and …

Reference data from other sheets Google Sheets function list Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to …

Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project …

Named functions let you create custom functions that can use built-in Sheets formulas. We've added the ability to import named functions so you can use them in more than one sheet.

The AI function doesn’t have access to your entire spreadsheet or other files in your Google Drive. To provide data or context to your prompt, add the data to your current spreadsheet and use the …

Notes If only a single number for value1 is supplied, SUM returns value1. Although SUM is specified as taking a maximum of 30 arguments, Google Sheets supports an arbitrary number of arguments for …

See the sum & average IF function QUERY function COUNTIF VLOOKUP Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and …

Named functions let you create custom functions that can use built-in Sheets formulas. We've added the ability to import named functions so that you can use them in more than one sheet.

Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project …