We will use "<>" to represent the condition "other then" and then will look into the range for the given criteria and then COUNTFI will return the final count.
Counting with Countif in given range of dates
Counting blank cells in a given range in excel.
How to count cell that are not blank
Counts the number of cells within a range that meet the given criteria
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM