Please enable JavaScript to view the comments powered by Disqus.


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

Counting between given range with COUNTIFS function 

The COUNTIF() function has ability to look for multiple criteria in multiple range, thus giving the final count. 


Lets chat on this