Count unique numeric values in a range |
SUM COUNTIF FREQUENCY |
Count unique numeric values with criteria |
SUM FREQUENCY |
Count unique text values in a range |
MATCH ROW SUMPRODUCT FREQUENCY |
Count unique text values with criteria |
MATCH ROW SUM FREQUENCY |
Count unique values in a range with COUNTIF |
SUMPRODUCT COUNTIF |
Count visible rows in a filtered list |
SUBTOTAL |
Count visible rows only with criteria |
|
COUNTIFS with multiple criteria and OR logic |
COUNTIFS |
Running count of occurrence in list |
COUNTIF |
Summary count with COUNTIF |
COUNTIF |