If auxiliary columns are used, the following formula can be used.

=SUMPRODUCT(TEXT(A4-E3:E6，" 0； ! 0")*G3:G6)

If you use a constant array directly, you can use the following formula.

= SUM(TEXT(A5-{ 0； 100; 200; 300},"0; ! 0")*{0.2; 0. 1; 0. 1; 0. 1})

The detailed introduction of step charging (progressive charging) can refer to Baidu's experience.

Web page link