I got a result by setting up like this: headers Model, Qty, Price in
A1:C1; relevant data (the sample from your post) in B2:C7. I entered
numeric headers 1, 100, 1000, and 2500 in B10:E10 and representative
entries AB123, AB125, and BA222 in A11:A13. I entered this formula in
B11:
=SUMPRODUCT(--($A11=$A$2:$A$7),--(B$10=$B$2:$B$7),$C$2:$C$7)
.... which you can copy and paste to the other cells in the grid. You
can suppress the cells that return 0 with conditional formatting, if
desired.