SUMPRODUCT Problem

[MarkMMcGuireNEUK]

The SUMPRODUCT formula I am using is not returning the expected result. Can anyone please help me?
I am trying to write a formula to calculate the bill for 10,000 units whose price reduces with volume.
Not sure why I am getting the calculated value of £82,576.50 instead of £63,682.00?
If there is an error I can't see where?

Formula in C7 is =SUMPRODUCT(--(C6>{50,2500,5000,10000}),--(C6-{50,2500,5000,10000}),{12.47,-4.14,-2.09,-0.83})

Many thanks in advance. Mark

Band from	Band to	Charged	Price	Reduction	Total
0​	50​	50​	£ 12.47		£ 623.50
51​	2,500​	2,450​	£ 8.33	£ 4.14	£ 20,408.50
2,501​	5,000​	2,500​	£ 6.24	£ 2.09	£ 15,600.00
5,001​	10,000​	5,000​	£ 5.41	£ 0.83	£ 27,050.00
		10,000​		Totals	£ 63,682.00
		£ 82,576.50
				Difference is	£ 18,894.50	over

 

[Dave Patton]

Commission2022.xlsm
	A	B	C	D	E	F
1
2		Sold	10,000.00	63,682.00	63,682.00	63,682.00
3
4		Brackets	Rates	Amount
5
6		0	12.47
7		50	8.33
8		2,500	6.24
9		5,000	5.41
11b

Cell Formulas
Range	Formula
D2	D2	=SUMPRODUCT(--(C2>B6:B9),C2-B6:B9,C6:C9-C5:C8)
E2	E2	=SUMPRODUCT(--(C2>{0;50;2500;5000}),C2-{0;50;2500;5000},{12.47;-4.14;-2.09;-0.83})
F2	F2	=SUM((C2>{0;50;2500;5000})*(C2-{0;50;2500;5000})*{12.47;-4.14;-2.09;-0.83})

 

[Dave Patton]

Try using Formula Evaluate to see the logic that is used.
I included an edit of your formula

Commission2022.xlsm
	A	B	C	D	E	F	G
1
2
3
4
5
6		Sold	10,000.00	63,682.00	63,682.00	63,682.00	63,682.00
7
8		Brackets	Rates	Amount
9
10		0	12.47
11		50	8.33
12		2,500	6.24
13		5,000	5.41
11b

Cell Formulas
Range	Formula
D6	D6	=SUMPRODUCT(--(C6>B10:B13),C6-B10:B13,C10:C13-C9:C12)
E6	E6	=SUMPRODUCT(--(C6>{0;50;2500;5000}),C6-{0;50;2500;5000},{12.47;-4.14;-2.09;-0.83})
F6	F6	=SUM((C6>{0;50;2500;5000})*(C6-{0;50;2500;5000})*{12.47;-4.14;-2.09;-0.83})
G6	G6	=SUMPRODUCT(--(C6>{0,50,2500,5000}),(C6-{0,50,2500,5000}),{12.47,-4.14,-2.09,-0.83})