The COUNTIFS formula is used to count cells between two numbers in a specific criteria. Here we will learn how to count cells between two numbers using COUNTIFS formula.
To count cells between two numbers we use COUNTIFS formula, in another worlds, this formula will help us to know that how many numbers are there between given criteria.
To start formula type = (Equal).
Type Countifs.
Start ( (Bracket).
Select Range of dates.
Type , (comma).
Type ” (Inverted comma).
Type > (Greater sign).
Type = (Equal).
Type the Starting number (First Number).
Close ” (Inverted Comma).
Type , (Comma).
Select Range of dates again.
Type , (Comma).
Star ” (Inverted Comma).
Type < (Less than).
Type = (Equal).
Type the ending number (Second Number).
Close ” (Inverted Comma).
Close the Bracket.
For example:
We have a range of dates between 01/02/2020 to 06/06/2020, and we want to know that how many cells are there between given dates.
count cells between two dates
The formula will be:
=COUNTIFS(F2:F25,”>=80″,F2:F25,”<=160″)
Where F2:F25 is range of cells
80 is starting number of two number
160 is ending number of date of range
The result is 6.
