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
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