COUNTIFS(...)
Using countif between dates when start and end dates are known
Used Functions
Category: Statistical
Counts the number of cells within a range that meet multiple criteria
Syntax
COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
Practice COUNTIFS Formula at Sheetzoom
COUNTIFS formula at Microsoft help
0
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.