Regular Plus

Everyday functions your spreadsheet doesn’t have: count the blanks, count unique values, find the earliest date, and more.

Function	Description
AVERAGE_DATE	Average of date values in cells, ranges, or data fields.
COUNT_BLANK	Count of blank values in cells, ranges, or data fields.
COUNT_DATE	Count of date values in cells, ranges, or data fields.
COUNT_DATE_UNIQUE	Count of unique date values in cells, ranges, or data fields.
COUNT_ERROR	Count of cells with errors in cells, ranges, or data fields.
COUNT_FALSE	Count of FALSE values in cells, ranges, or data fields.
COUNT_NOT_BLANK	Count of non-blank values in cells, ranges, or data fields.
COUNT_TEXT	Count of text values in cells, ranges, or data fields.
COUNT_TEXT_UNIQUE	Count of unique text values in cells, ranges, or data fields.
COUNT_TRUE	Count of TRUE values in cells, ranges, or data fields.
COUNT_UNIQUE	Count of unique numeric values in cells, ranges, or data fields.
MAX_DATE	Maximum (latest) date value in cells, ranges, or data fields.
MAX_TEXT	Maximum (alphabetically last) text value in cells, ranges, or data fields.
MEDIAN_DATE	Median (middle) date value in cells, ranges, or data fields.
MIN_DATE	Minimum (earliest) date value in cells, ranges, or data fields.
MIN_TEXT	Minimum (alphabetically first) text value in cells, ranges, or data fields.