Please enable JavaScript to view the comments powered by Disqus.


COUNTIFS(...B4:B11,">="&B13,B4:B11,"<="&B14)

Using countif between dates when start and end dates are known

COUNTIFS function takes four arguments, lookup range and criteria and then the second lookup range and the respective criteria. Thus it checks for the two criteria in respective ranges and returns the count. 


Used Functions

Category: Statistical

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

Syntax

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

Lets chat on this