In cell C6 I need the cum product of 2 columns of matching data. There are 3 items in column A that match 3 Items in Column E
In Cell C6 I would like a formula that would multiply the qty and and to a sum total. I hope my example makes sense
using DSUM I can get the total of any of the Quanties, but not sure how to expand the formula that I need.
In Cell C6 I would like a formula that would multiply the qty and and to a sum total. I hope my example makes sense
using DSUM I can get the total of any of the Quanties, but not sure how to expand the formula that I need.
| Book2 | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 1 | PartNo | Description | PartNo | Description | Qty | ||||
| 2 | 020700 | AssySucNozHydTiltLhMajor | 10 | 10X4=40 | 020700 | AssySucNozHydTiltLhMajor | 4 | ||
| 3 | 027143 | AssySucNozAirRh8000 | 20 | 20X5=100 | 021680 | AssyFrontSprayBarLowPressure | 7 | ||
| 4 | 036726 | AssyB/HeadSideR/H/D | 1 | 12X4=48 | 023282 | AssySucNozPuHydLhMajor | 4 | ||
| 5 | 030501 | AssyBlankingFlapValveSingleVmMinor | 5 | 40+100+48=188 | 023283 | AssySucNozPuHydRhMajor | 4 | ||
| 6 | Steve | Test | 188 | 023623 | AssySucNozAirLhMajor98- | 4 | |||
| 7 | 034784 | AssyBrakePedalRhVmMinorFl | 1 | 023624 | AssySucNozAirRhMajor98- | 4 | |||
| 8 | 024553 | AssyBrushCore1300LargeWidesweep | 2 | 027142 | AssySucNozAirLh8000 | 5 | |||
| 9 | 024554 | AssyBrushCore1300SmallWidesweep | 3 | 027143 | AssySucNozAirRh8000 | 5 | |||
| 10 | 024382 | AssyBrushCoreDualSweepMinor | 4 | 036135 | AssySucNozHydLhNcPlaningType | 5 | |||
| 11 | 023169 | AssyBrushCoreLarge7000 | 5 | 020730 | AssySucNozHydTiltRhMajor | 5 | |||
| 12 | 025662 | AssyBrushCoreLarge80/85 | 6 | 027144 | AssySucNozAirLhRubberLined8000 | 5 | |||
| 13 | 032482 | AssyBrushCoreMagnumPoly/WireMix | 7 | 027145 | AssySucNozAirRhRubberLined8000 | 5 | |||
| 14 | 030691 | AssyBrushCoreMerlinPoly/WireMix | 8 | 027719 | AssySucNozHydLh8000 | 5 | |||
| 15 | 023075 | AssyBrushCoreMinorW/Sweep | 9 | 027720 | AssySucNozHydRh8000 | 5 | |||
| 16 | 037356 | AssyBrushCoreMinorW/SweepHardPoly | 10 | 027721 | AssySucNozHydLhPu8000 | 5 | |||
| 17 | 023168 | AssyBrushCoreSmall3/5/6000 | 11 | 027722 | AssySucNozHydRhPu8000 | 5 | |||
| 18 | 028163 | AssySucNozPuAirLhMajor | 12 | 028163 | AssySucNozPuAirLhMajor | 4 | |||
| 19 | 018201 | AssyBrushFrontN/SL/H/DMinor | 13 | 028164 | AssySucNozPuAirRhMajor | 4 | |||
| 20 | 023276 | AssyBrushFrontN/SR/H/DMinor | 14 | 028670 | AssySucNozAirLhNcPlaning | 5 | |||
| 21 | 028671 | AssySucNozAirRhNcPlaningType | 5 | ||||||
| 22 | 028764 | AssySucNozRhM30 | 3 | ||||||
| 23 | 037379 | AssySucNozRhM30P.U. | 3 | ||||||
| 24 | 028828 | AssySucNozPuAirLhNcPlaningType | 5 | ||||||
| 25 | 028829 | AssySucNozPuAirRhNcPlaningType | 5 | ||||||
| 26 | 028932 | AssySucNozAirLh8000NarrowTrack | 5 | ||||||
| 27 | 028933 | AssySucNozAirRh8000NarrowTrack | 5 | ||||||
| 28 | 032257 | AssySucNozAirLhXp | 4 | ||||||
| 29 | 022196 | AssySideBrushRhdM26.2Vw/Iveco | 1 | ||||||
Sheet3 | |||||||||
