New

New functions for analyzing your data, like COUNT_IF and SUM_IF: count, total, or average only the rows that match a condition.

Function	Description
AVERAGE_DATE_IF	Average of date values in a range, filtered by one or more conditions.
AVERAGE_IF	Average of numeric values in a range, filtered by one or more conditions.
BLANK	Produces a blank value in the cell.
COUNT_BLANK_IF	Count of blank values in a range, filtered by one or more conditions.
COUNT_DATE_IF	Count of date values in a range, filtered by one or more conditions.
COUNT_DATE_UNIQUE_IF	Count of unique date values in a range, filtered by one or more conditions.
COUNT_ERROR_IF	Count of cells with errors in a range, filtered by one or more conditions.
COUNT_FALSE_IF	Count of FALSE values in a range, filtered by one or more conditions.
COUNT_IF	Count of numeric values in a range, filtered by one or more conditions.
COUNT_NOT_BLANK_IF	Count of non-blank values in a range, filtered by one or more conditions.
COUNT_TEXT_IF	Count of text values in a range, filtered by one or more conditions.
COUNT_TEXT_UNIQUE_IF	Count of unique text values in a range, filtered by one or more conditions.
COUNT_TRUE_IF	Count of TRUE values in a range, filtered by one or more conditions.
COUNT_UNIQUE_IF	Count of unique numeric values in a range, filtered by one or more conditions.
FORMULA_TEXT	Shows the formula of the specified cell.
MAX_AVERAGE	Finds which group has the highest average.
MAX_COUNT	Finds which group has the highest count.
MAX_DATE_IF	Maximum (latest) date value in a range, filtered by one or more conditions.
MAX_IF	Maximum numeric value in a range, filtered by one or more conditions.
MAX_SUM	Finds which group has the highest total.
MAX_TEXT_IF	Maximum (alphabetically last) text value in a range, filtered by one or more conditions.
MEDIAN_DATE_IF	Median (middle) date value in a range, filtered by one or more conditions.
MEDIAN_IF	Median (middle) numeric value in a range, filtered by one or more conditions.
MIN_AVERAGE	Finds which group has the lowest average.
MIN_COUNT	Finds which group has the lowest count.
MIN_DATE_IF	Minimum (earliest) date value in a range, filtered by one or more conditions.
MIN_IF	Minimum numeric value in a range, filtered by one or more conditions.
MIN_SUM	Finds which group has the lowest total.
MIN_TEXT_IF	Minimum (alphabetically first) text value in a range, filtered by one or more conditions.
MODE_IF	Most frequent value in a range, filtered by one or more conditions.
NA	Produces a #NA! error in the cell.
SATISFY_ALL	Multi-field AND constraint for filtering.
SATISFY_ANY	Multi-field OR constraint for filtering.
SHOW	Shows the formula of the specified cell.
SUM_IF	Sum of numeric values in a range, filtered by one or more conditions.
VALUE_IF	First value in a range, filtered by one or more conditions.