In Sheets, with lower edges in column G and upper edges in column H, type the COUNTIFS for row 2 that counts amounts in [G2, H2).
In Sheets, with lower edges in column G and upper edges in column H, type the COUNTIFS for row 2 that counts amounts in [G2, H2).
Answer
=COUNTIFS(D2:D13, ">="&G2, D2:D13, "<"&H2)
Two range–criterion pairs on the same locked range. The & glues the operator to the edge cell. Filled down: 4, 4, 2, 1, 1.