Please enable JavaScript to view the comments powered by Disqus.


Using countif to count between date range

We actually use COUNTIFS() to count for such cases, it takes multiple lookup ranges and multiple criteria with logical operators to give the result

Used Functions

Category: Statistical

Counts the number of cells within a range that meet multiple criteria


COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Lets chat on this