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

Skip to content
# Excel Formulas

# Archives

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

## The formula to count unique numeric values in a range

All formulas in Microsoft Excel

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!

This formula is exactly what you want. You can use a formula that uses the FREQUENCY function together with the SUM function to count unique numeric values in a range.