How to count values with OR operator

How to count values with OR operator

You can count values in Excel by multiple criteria using the COUNTIFS function. However COUNTIFS will only link those criterion by AND operation. If you want to COUNTIFS OR, you need an alternative approach. This article shows how to count values with OR operator...
How to count characters in Excel in a range

How to count characters in Excel in a range

The LEN function is used to count characters in Excel. But it doesn’t support ranges or arrays to easily count total number of characters in a range. This article shows 2 ways to count characters in Excel in a range which uses SUMPRODUCT and SUM along with LEN....
How to check if a value exists in a list

How to check if a value exists in a list

The logical tests and conditional checks have important role in Excel models. Potential errors can be detected and handled by using the right logical tests. If you know How to check if a value exists in a list, you can use this logical statement to detect and...
How to count values by length

How to count values by length

This article shows how to count values by length based on their character count. This method can be helpful to check your data against invalid entries. It is also a good practice to use SUMPRODUCT and N functions together. Syntax =SUMPRODUCT(N(LEN(range)>character...
How to SUM 2d ranges with SUMPRODUCT

How to SUM 2d ranges with SUMPRODUCT

Summing values by a condition may sound easy. If not, please see Crunch Data Even Faster with the SUMIFS Function article as well. You can easily sum values by condition(s) with SUMIF and SUMIFS functions; with a limitation. The sum range and criteria ranges should...