The AVERAGE function returns the numerical average value in a dataset, ignoring text. Examples Make a copy

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 …

QUERY function Runs a Google Visualization API Query Language query across data. Sample Usage QUERY(A2:E6,"select avg(A) pivot B") QUERY(A2:E6,F2,FALSE) Syntax QUERY(data, query, …

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 …

Use the AI function in Sheets You can use the AI function to: Generate text: To generate text tailored to your data, Google Workspace with Gemini uses relevant information from your sheet. Summarize …

The RANDARRAY function generates an array of random numbers between 0 and 1. The size of the array is determined by the provided rows and columns arguments. Parts of a RANDARRAY function …

TOCOL function TOROW function VSTACK function WRAPCOLS function WRAPROWS function Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, …

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 …

QUERY function SPARKLINE Create & use named functions LAMBDA function 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 you can use them in more than one sheet.