ultracyclist
Active Member
- Joined
- Oct 6, 2010
- Messages
- 274
- Office Version
- 365
- Platform
- Windows
I have my data as shown in rows G7 thru M31. I want to create a formula on each row in column M that takes the value in the quantity columns and the text values in the adjacent rows and gives a sum total.
Ex: Yellow= 270, Blue = 2,430, Red =7500, Black 15360, and Green = 870
Here’s two examples
If I enter 2 in the Qty column (G3) and Yellow in the color column (H3) it should return a value of 540 on row M3
Another example
If I enter 3 in a Qty column (G6) and Blue in the color column (H6) then enter 4 in another Qty column (K6) and Black in the color column (L6) the value should return a value of 68,730 on row M6
Any suggestions on how to create this formula?
Thanks,
Allen
Ex: Yellow= 270, Blue = 2,430, Red =7500, Black 15360, and Green = 870
Here’s two examples
If I enter 2 in the Qty column (G3) and Yellow in the color column (H3) it should return a value of 540 on row M3
Another example
If I enter 3 in a Qty column (G6) and Blue in the color column (H6) then enter 4 in another Qty column (K6) and Black in the color column (L6) the value should return a value of 68,730 on row M6
Any suggestions on how to create this formula?
Code:
<style type="text/css">
.tg {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg .tg-yw4l{vertical-align:top}
</style>
[TABLE="class: tg"]
<tbody>[TR]
[TH="class: tg-yw4l"]Qty
[/TH]
[TH="class: tg-yw4l"]Color
[/TH]
[TH="class: tg-yw4l"]Qty
[/TH]
[TH="class: tg-yw4l"]Color
[/TH]
[TH="class: tg-yw4l"]Qty
[/TH]
[TH="class: tg-yw4l"]Color
[/TH]
[TH="class: tg-yw4l"]Total
[/TH]
[/TR]
[TR]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[/TR]
[TR]
[TD="class: tg-yw4l"]2
[/TD]
[TD="class: tg-yw4l"]Yellow
[/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"]540.00
[/TD]
[/TR]
[TR]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[/TR]
[TR]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[/TR]
[TR]
[TD="class: tg-yw4l"]3
[/TD]
[TD="class: tg-yw4l"]Blue
[/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"][/TD]
[TD="class: tg-yw4l"]4
[/TD]
[TD="class: tg-yw4l"]Black
[/TD]
[TD="class: tg-yw4l"]68,730.00
[/TD]
[/TR]
</tbody>[/TABLE]
Thanks,
Allen