The gap still exists. The last band should be 2301 to 2400 for consistency.

=SUMPRODUCT((E$3:E$26 >= LEFT(B3,4)) * (E$3:E$26 <= RIGHT(B3,4)))