Count
Count cells between dates COUNTIFSDATE
COUNTIFSCOUNTIF
Count cells between two numbers
Count cells equal to COUNTIF
Count cells equal to case sensitive SUMPRODUCTEXACT
Count cells equal to either x or y COUNTIF
Count cells equal to one of many things COUNTIFSUMPRODUCT
Count cells greater than COUNTIF
COUNTIF
Count cells less than
Count cells not equal to COUNTIF
Count cells not equal to many things MATCHISNASUMPRODUCT
Count cells not equal to x or y COUNTIFSSUMPRODUCT
Count cells over 100 characters SUMPRODUCTLENN
Count cells that are blank COUNTBLANKCOUNTA
COUNTACOUNTIFCOUNTIFS
Count cells that are not blank
COUNTIF
Count cells that begin with
COUNTIFSUMPRODUCTISNUM
Count cells that contain either x or y
BERFIND
Count cells that contain errors SUMPRODUCTISERRORISERR
Count cells that contain five characters COUNTIF
Count cells that contain negative numbers COUNTIF
COUNT
Count cells that contain numbers
SUMPRODUCTMOD
Count cells that contain odd numbers
Count cells that contain positive numbers COUNTIF
Count cells that contain specific text COUNTIFSUMPRODUCTFINDIS
NUMBER
COUNTIFISTEXTSUMPRODUCT
Count cells that contain text
COUNTIFS
COUNTIF
Count cells that do not contain
Count cells that do not contain errors ISERRORNOTSUMPRODUCT
Count cells that do not contain many strings ISNUMBERSEARCHMMULTTRA
NSPOSE
COUNTIF
Count cells that end with
Count dates by day of week SUMPRODUCTWEEKDAY
Count dates in given year YEARSUMPRODUCT
Count if row meets internal criteria SUMPRODUCT
Count if row meets multiple internal criteria SUMPRODUCT
Count if two criteria match COUNTIFSSUMPRODUCT
COUNTIFS
Count items in list
Count long numbers without COUNTIF SUMPRODUCTCOUNTIF
Count matches between two columns SUMPRODUCT
Count multiple criteria with NOT logic SUMPRODUCTISNAMATCH
Count numbers by range with COUNTIFS COUNTIFS
Count numbers that begin with SUMPRODUCTLEFT
Count numbers third digit equals 3 SUMPRODUCTMID
Count occurrences in entire workbook COUNTIFSUMPRODUCT
Count paired items in listed combinations COUNTIFSCONCAT
Count rows that contain specific values MMULTCOLUMNTRANSPOSE
Count rows with at least n matching values MMULTCOLUMNTRANSPOSE
SUMPRODUCT
Count rows with multiple OR criteria
Count sold and remaining COUNTA
Count total matches in two ranges SUMPRODUCTCOUNTIF
Count unique numeric values in a range FREQUENCYSUMCOUNTIF
Count unique numeric values with criteria FREQUENCYSUM
FREQUENCYMATCHROWSUMP
Count unique text values in a range
RODUCT
Count unique text values with criteria FREQUENCYMATCHROWSUM
Count unique values in a range with COUNTIF SUMPRODUCTCOUNTIF
Count visible rows in a filtered list SUBTOTAL
Count visible rows only with criteria SUBTOTALOFFSETSUMPRODUC
T
COUNTIFINDIRECT
COUNTIF with non-contiguous range
COUNTIFS with multiple criteria and OR logic COUNTIFS
COUNTIF
Running count of occurrence in list
Summary count by month with COUNTIFS COUNTIFSEDATE
Summary count of non-blank categories COUNTIFS
COUNTIF
Summary count with COUNTIF
Summary count with percentage breakdown COUNTIFCOUNTA
SUMPRODUCT count multiple OR criteria SUMPRODUCT
COUNTIFS
Two-way summary count with COUNTIFS
