37 functions to practice

Each function page explains what the function does, shows its syntax, and lists the exercises on Sheetsdrill that use it.

• ARRAYFORMULAARRAYFORMULA applies a formula to a whole range at once instead of one cell at a time, in Google Sheets. 3 exercises.
• AVERAGEAVERAGE returns the arithmetic mean of its arguments, ignoring empty cells and text. 1 exercise.
• AVERAGEIFSAVERAGEIFS averages the cells that meet several conditions at once. 1 exercise.
• COUNTCOUNT counts the cells that contain numbers. 1 exercise.
• COUNTACOUNTA counts the cells that are not empty, whatever they contain. 3 exercises.
• COUNTIFCOUNTIF counts the cells in a range that meet one condition. 1 exercise.
• COUNTIFSCOUNTIFS counts the rows that meet several conditions at once. 2 exercises.
• DATEDIFDATEDIF returns the number of complete days, months or years between two dates. 1 exercise.
• EOMONTHEOMONTH returns the last day of the month a given number of months away. 1 exercise.
• FILTERFILTER returns the rows of a range that meet one or more conditions, in Google Sheets. 3 exercises.
• IFIF returns one value when a condition is TRUE and another when it is FALSE. 4 exercises.
• IFNAIFNA returns a replacement value only when a formula produces #N/A, the error a failed lookup gives. 1 exercise.
• IFSIFS checks several conditions in order and returns the value for the first one that is TRUE. 1 exercise.
• INDEXINDEX returns the value at a given row and column position in a range. 5 exercises.
• JOINJOIN concatenates the values of a range with a delimiter between them, in Google Sheets. 1 exercise.
• LENLEN returns the number of characters in a text. 1 exercise.
• MATCHMATCH returns the position of a value in a range. 2 exercises.
• MAXIFSMAXIFS returns the largest value among the cells that meet one or more conditions. 1 exercise.
• MINIFSMINIFS returns the smallest value among the cells that meet one or more conditions. 1 exercise.
• NETWORKDAYSNETWORKDAYS returns the number of working days between two dates, excluding weekends and optional holidays. 1 exercise.
• QUERYQUERY runs a SQL-like query over a range, with select, where, group by, order by and limit, in Google Sheets. 3 exercises.
• REGEXEXTRACTREGEXEXTRACT returns the first part of a text that matches a regular expression, in Google Sheets. 1 exercise.
• REGEXMATCHREGEXMATCH returns TRUE when a text matches a regular expression, in Google Sheets. 1 exercise.
• REGEXREPLACEREGEXREPLACE replaces the parts of a text that match a regular expression, in Google Sheets. 1 exercise.
• ROUNDROUND rounds a number to a given number of decimal places. 2 exercises.
• SORTSORT returns a range sorted by one or more columns, in Google Sheets. 1 exercise.
• SORTNSORTN returns the first n rows of a range after sorting it, in Google Sheets. 1 exercise.
• SPLITSPLIT divides a text around a delimiter into separate cells, in Google Sheets. 1 exercise.
• SUMSUM adds its arguments, ignoring text and empty cells. 6 exercises.
• SUMIFSSUMIFS adds the cells that meet several conditions at once. 2 exercises.
• SWITCHSWITCH compares a value against a list of cases and returns the matching result. 1 exercise.
• TEXTTEXT converts a number or date into text in a given format. 1 exercise.
• TEXTJOINTEXTJOIN joins several texts with a delimiter, optionally skipping empty cells. 1 exercise.
• UNIQUEUNIQUE returns the distinct values in a range, in Google Sheets. 1 exercise.
• VALUEVALUE converts a number stored as text into a real number. 1 exercise.
• VLOOKUPVLOOKUP searches the first column of a range and returns a value from another column in the same row. 4 exercises.
• XLOOKUPXLOOKUP searches a range and returns the matching item from another range, with a built-in result for a missing value. 4 exercises.