First of all, I've pretty much NEVER used Excel in my life. I've always been pretty daunted and intimidated by the tool.
What I want to do is simple. Basically I am doing a project that involves many, many tedious multiplication and addition problems. I have a bunch of values set for a certain attribute, and then a variable (this is the only thing I want to enter manually for each calculation) to multiply it with. After I find out the values of all the different attributes multiplied by the variables, I want to add all of the values together.
For example, say I have item A.
Item A has:
175 of the attribute with a value of 100 units. 175 * 100 = 17500
20 of the attribute with a value of 50 units. 20 * 50 = 1000
40 of the attribute with a value of 5 units. 40 * 5 = 200
17500 + 1000 + 200 = 18700 total units
It's a very simple operation, and I'd save a good 15-20 hours of tedious work by figuring out how to do this. Any help is greatly appreciated.
-Will-
Bookmarks