## Formula to count group numbers into ranges

To group numeric data into ranges, you can build a summary table and use COUNTIFS to count values at each threshold.

## Formula to count cells on multiple criteria using OR logic

This formula will help you count cells on multiple criteria using OR logic by use the COUNTIFS function with an array constant.

## Formula to count dates by weekday in Excel

In fact, there are many cases need to use this formula to solve the problem! Suppose you have a row contains day have the event, and you want to count how many events on Monday!

## Formula to count visible rows only with criteria

To count visible rows only with criteria, you can use a rather complex formula based on SUMPRODUCT, SUBTOTAL, and OFFSET function.

## Formula to count visible rows in a filtered list

You have a filtered list and want to count visible rows in this list. In Excel, you can use the SUBTOTAL function to do that. The formula will automatically ignore rows that are hidden by a filter.

## Formula to count unique text values in a range

Suppose you want to know how many students in a class have the same name. Have two ways can help do that.

## The formula to count unique numeric values with criteria

To do that in excel, you can use a formula based on the SUM and FREQUENCY functions, together with the FUNCTION to apply criteria.

## The formula to count cells that end with characters

Suppose you want to count all products in the cells that have the same end of the product code. This article helps you solve this problem!