## 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.

Skip to content
# Category: Count

## Formula to count group numbers into ranges

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

## Formula to count dates by weekday in Excel

## Formula to count visible rows only with criteria

## Formula to count visible rows in a filtered list

## Formula to count unique text values in a range

## The formula to count unique numeric values with criteria

## The formula to count cells that end with characters

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

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

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!

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

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.

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

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

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!