Alternative to SUMPRODUCT?

Forgot to multiply by 1000 on the first couple.

Also, changed the formula to:

=SUM(MIN(CEILING(Purchase!B3,1000),A3)*B2,MAX(0,MIN(SUM(A2:A4),CEILING(Purchase!B3,1000)-SUM(A2:A3)))*B3,MAX(0,MIN(SUM(A2:A5),CEILING(Purchase!B3,1000)-SUM(A2:A4)))*B4,MAX(0,MIN(SUM(A2:A6),CEILING(Purchase!B3,1000)-SUM(A2:A5)))*B5,MAX(0,MIN(SUM(A2:A7),CEILING(Purchase!B3,1000)-SUM(A2:A6)))*B6,MAX(0,(CEILING(Purchase!B3,1000)-SUM(A2:A7)))*B7)/1000

Try that.