Google Sheets function list
The 17 types in Google’s list
Google prints every function in its list under a type. These are the 17 types the list carried when this site fetched it, with the number of functions in each.
AI1 functionsFunctions that ask a language model and return its answer into the sheet.
Array29 functionsFunctions that work on whole ranges at once and return arrays.
Database12 functionsFunctions that summarise values in a range using a criteria table.
Date26 functionsFunctions that read, build or measure dates and times.
Engineering47 functionsFunctions for engineering and complex-number work.
Filter4 functionsFunctions that filter, sort and de-duplicate a range.
Financial50 functionsFunctions for interest, payments, securities and depreciation.
Google7 functionsFunctions that reach Google services from inside a spreadsheet.
Info18 functionsFunctions that report on a cell or a value.
Logical13 functionsFunctions that test conditions and choose between results.
Lookup17 functionsFunctions that find values and addresses in a range.
Math84 functionsArithmetic, rounding, trigonometry and complex numbers.
Operator17 functionsOperators that Google’s list prints with a call syntax.
Parser6 functionsFunctions that turn text into another type of value.
Statistical136 functionsFunctions for averages, distributions, tests and trends.
Text41 functionsFunctions that inspect, cut, join or convert text.
Web8 functionsFunctions that take data from the web into a sheet.
Source: Google Docs Editors Help, “Google Sheets function list” (support.google.com/docs/table/25273), data fetched 28 September 2026. Data month: September 2026.