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)))
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)))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks