Tiered Pricing using SumProduct

[SR2017]

Hello,

I am attempting to write a formula for distributed/cumulative tiered pricing and am not able to get the formula correctly.

1 - 30 units = $90/unit
31 - 60 units = $75/unit
61 - 100 units = $60/unit
More than 100 units = $55/unit

Examples of expected calculations are:
55 Units: (30*90)+(25*75)
75 Units: (30*90)+(30*75)+(15*60)

I tried using the following formula and was only able to get it to work for the first two tiers and not the last two.
F7 is the value of the # of units I want to calculate for.
=sumproduct(--(F7>{0,30,60,100}),--(F7-{0,30,60,100}),{90,-15,-15,-5})

Any insight I can get on this is greatly appreciated!!

 

[Jonmo1]

It works as expected for me

Can you give example values that gave the wrong result? What result did it give, what result did you expect..