Count cells not equal to x or y using COUNTIF

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

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.

Category - Count