In this article, I’ll explain how to count cells that contain odd numbers in Excel. This example uses two functions: SUMPRODUCT and MOD. Before we begin, I suggest that you download the exercise file. The syntax If you are familiar with SUMPRODUCT, then the syntax for this formula really simple: =SUMPRODUCT(--(MOD(range, 2)=1)) where range is […]

It’s very common to get a database that contains a column with full names, separated either by space, comma, or a mix of symbols. That is why it’s important to understand how you can easily separate first and last name in Excel. This article will save you a lot of time, as it shows you […]

If you are looking to count cells not between two numbers in Excel using COUNTIFS, then you are in for a disappointment. That’s because COUNTIFS uses the AND logic when comparing the criteria, resulting in an always FALSE result. And that makes sense since a number can’t be, for example, higher than 100 and lower […]

To get the first day of the month for a given date, you can use two simple approaches: using EOMONTH function or using DAY function.

You can count all cells not equal to x or y using a simple COUNTIFS formula. If you only want to count using one condition, then you can also use COUNTIF as an alternative. I’ll explain both in this short tutorial. Count cells not equal to x or y using COUNTIFS The COUNTIFS syntax for […]