i have a data table laid out in the following manner;
ColA ColB ColC ColD ColE ColF
Product Desc Ohio Georgia NewYork Indiana
X A 5 4 3 4
Y B 3 2 5 1
Z C 6 3 6 2
I want to create a sumtotal in ColG from ColC,ColD,ColE and ColF but all vaules in ColC have to be multiplied by a factor of 2, colD by 3, colE by 1.5 and colF by 3.5.
This list is dynamic and can grow by rows and columns. The factor by which a state is multiplied will always be the same for the state. Essentially, the factor for all states will be coded and will never change.
How can i loop through all the col's with state names, evaluate the name, apply the factor and sum the result for every state in colG.
this what i use to just sum the data by product
But i also need to need to add the factors based on the state name and sum all that as well. Any ideas on how to get there will be helpfull.
Thanks
Bookmarks