Units
775

Min Max Price
1 250 $17.00
251 500 $15.00
501 750 $13.00
751 1,000 $11.00

I am trying to determine what I am missing above that is not producing the right result below. The formula I am working with is:

=SUMPRODUCT(--(A1>{0,250,500,750,1000}),A1-{0,250,500,750,1000},{17,-2,-4,-6,-6})

A1 is the # of units. The correct number is $11,525 (for 775 units) but I keep getting $10,875 with this formula so I am not sure what I am doing wrong. In case you are wondering the final "-6" I simply placed in there so the formula would actually produce a number otherwise it was "Value"

I would appreciate some guidance.