# Category - Count

## Count cells that contain odd numbers with SUMPRODUCT

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

## Count cells not between two numbers

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

## Count cells not equal to x or y using COUNTIFS

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 equal to a specific value

Counting cells that equal to a specific value can be achieved using COUNTIF function. If you need to use multiple criteria you can also use COUNTIFS.

## Count cells between two dates using COUNTIFS

You can use the COUNTIFS function to count the number cells between two dates of an Excel file. Example file included.