Christopher
New member
Assume Product is Part A and Qty is 4 for the following fields
(I expect the formula to output 25.87)
Field values are as follows:
A1
roduct B1rice C1:Qty Start D1: Qty End
A2artA B2:10.35 C2:50 D2:500
A3artA B3:12.94 C3:25 D3:49
A4artA B4:12.94 C4:10 D4:24
A5artA B5:25.87 C5:1 D5:9
A6artA B6:10.35 C6:0 D6:0
A7artB B7:8.34 C7:50 D7:500
A8artB B8:10.43 C8:25 D8:49
A9artB B9:10.43 C9:10 D9:24
A10artB B10:20.86 C10:1 D10:9
A11artB B11:8.34 C11:0 D11:0
Additional Details
Previous question was the same, except Quantity was 1 (which is in the Qty Start List). This question will need the answerer to allow for the fact that the quantity is BETWEEN QTY START and QTY END columns (in this case 1 and 9) and not exactly any number in the Qty start or Qty End list)
The previous correct solution was as follows:
=SUMPRODUCT((A2:A11=A2) * (C2:C11=1) * B2:B11)
(I expect the formula to output 25.87)
Field values are as follows:
A1
roduct B1rice C1:Qty Start D1: Qty EndA2
artA B2:10.35 C2:50 D2:500A3
artA B3:12.94 C3:25 D3:49A4
artA B4:12.94 C4:10 D4:24A5
artA B5:25.87 C5:1 D5:9A6
artA B6:10.35 C6:0 D6:0A7
artB B7:8.34 C7:50 D7:500A8
artB B8:10.43 C8:25 D8:49A9
artB B9:10.43 C9:10 D9:24A10
artB B10:20.86 C10:1 D10:9A11
artB B11:8.34 C11:0 D11:0Additional Details
Previous question was the same, except Quantity was 1 (which is in the Qty Start List). This question will need the answerer to allow for the fact that the quantity is BETWEEN QTY START and QTY END columns (in this case 1 and 9) and not exactly any number in the Qty start or Qty End list)
The previous correct solution was as follows:
=SUMPRODUCT((A2:A11=A2) * (C2:C11=1) * B2:B11)