Finding the average if values are weighted

[RachelLP]

I'm trying to figure out a way to make a consolidation of evaluations from a conference I just worked in excel. I've figured out that I can use a macro so every time I hit ctrl+d in a selected cell it will add 1 to the value of the cell. I've also figured out how to make it average the numbers of the row. The thing is the categories are weighted (1 through 10) and I'm trying to figure out the average that a certain category was rated but I can't figure out a good way for it to figure this out. If I average them as they are and I have 2 "3's" and 2 "10's" it's going to tell me the average is 2 when really the average is 6. I also need a good formula to input to tell it to omit the zero's. Any help would be greatly appreciated making a master evaluation of all the evaluations of a given conference takes up a ton of my time at work because I usually do them in word and do all the math and noting myself.

 

[venkat1926]

i guess sumproduct function will be of use to you if you have corresponding weights in another column

post a small extract of sheet and explain

 

[shg]

If you have 10 sets of raw results, and the weighted average of each (the same weights applied to all), then you have 10 equations in 10 unknowns and you can solve for the weights.

Post your data if you want an example.