Sumproduct find total price based on the range of users

[BBS90]

Hello
I am trying to calculate a price matrix per user based on the range of users and price against range
If there are 5 users, the price for each of 5 users is 20. If there are 8 users, the price for 1st 5 users is 20, then for the rest 3 users 18. 

I was helped by a community member to solve the issue using "SUMPRODUCT". But when I insert numbers like 1,2,6,7,11,12 etc the formula provided doesn't work as intended

The formula used is =SUMPRODUCT((B14>$B$3:$B$8+1)*(B14-$B$3:$B$8+1),$E$3:$E$8)

I am unable to understand the logic and what is wrong with the logic provided

https://we.tl/t-DcXPnQzJ5O 

Any help will be highly appreciated

[#2 · Accepted solution]

@BBS90 

See the attached version.

[#3]

Thanks a lot, @hans. It works