Google Sheets function list Google Sheets supports cell formulas typically found in most desktop spreadsheet packages. Functions can be used to create formulas that manipulate data and calculate …

Filter Google Sheets function list FILTER function SORT function SORTN Visit the Learning Center Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and …

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, …

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 …

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

Official Google Search Help Center where you can find tips and tutorials on using Google Search and other answers to frequently asked questions.

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 …

Query function using 'not contains' I have a master sheet with a list of people and their group. The group is either 'Grades 3-8', 'Grades 9-12', 'Senior Recreational', 'Senior (not a student', or 'Senior …

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 …

Syntax INDIRECT(cell_reference_as_string, [is_A1_notation]) cell_reference_as_string - A cell reference, written as a string with surrounding quotation marks. is_A1_notation - [OPTIONAL - TRUE …