countif_problem.png

countif_problem.png

Solution

This should work: =SUM(IF(E7>=Start,IF(E7<=End,1)))   as an array formula in cell G7.

Start is the range name for B7:B12

End is the range name for C7:C12

Complete the entry with Ctr+Shift+Enter and then copy it down into cells G8:G22