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.