![]() Bird Toy Parts, CHUNKY ROUNDS 16 US $7.85
|
![]() Munch Balls (qty 25) Bird Toy Parts US $17.95
|
![]() Mini Munch Balls (qty 25) Bird Toy Parts US $6.95
|
![]() 6mm Blue Plastic Chain (qty 25 ft) Bird toy parts US $16.00
|
![]() Bird Toy Parts, CHUNKY ROUNDS 8 US $4.15
|
![]() Bird Toy Parts ~ LARGE RHOMBOIDS 8 pk US $4.60
|
![]() Bird Toy Parts ~ MEDIUM RHOMBOIDS 16 pk US $5.25
|
![]() Bird Toy Parts ~ EXTRA SMALL RECTANGLE 25pk US $5.75
|
![]() Bird Toy Parts ~ SMALL WOOD SQUARES ~ 25 PK US $5.45
|

Excel 2007 Problem: Formula to return the correct price for the quantity given?
Assume Product is Part A and Qty is 1 for the following fields
(I expect the formula to output 25.87)
Field values are as follows:
A1:Product B1:PriceC1:Qty StartD1: Qty End
A2:PartA B2:10.35C2:50D2:500
A3:PartA B3:12.94C3:25D3:49
A4:PartA B4:12.94C4:10D4:24
A5:PartA B5:25.87C5:1 D5:9
A6:PartA B6:10.35C6:0 D6:0
A7:PartBB7:8.34C7:50D7:500
A8:PartBB8:10.43C8:25D8:49
A9:PartBB9:10.43C9:10D9:24
A10:PartBB10:20.86C10:1D10:9
A11:PartBB11:8.34C11:0D11:0
Preference is for a formula, but VBA will do if needed.
=SUMPRODUCT((A2:A11=A2) * (C2:C11=1) * B2:B11)
Delete the spaces before and after the asterisk symbol. Because if I post the formula without any space before and after the asterisk symbol then it's showing only haft of the formula and that is the reason I have given spaces in the above formula. So remove the spaces and paste it in excel.
------------------------
Ms-Exl-Learner
------------------------
Whats On My YouTube Today?
Top 10 Car Bumper Covers
Here Are A Few Items From Amazon You Might Be Interested In.
| Account limit of 2212 requests per hour exceeded. |
Items recently purchased on this site:
Thanks for visiting!


































