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...