Shanehaggerty
asked on
excel formula question
We are looking for a way to find the weighted average of a series of numbers relative to a percentage. We need the average of b17:e17 relative to c8:c:12. We have attached a screenshot of the document.
No attachment :)
Missing screenshot.
Usually doing sumproduct(range_values, range_Coefficients)/sum(va lues) works well for a weighted average
Thomas
Usually doing sumproduct(range_values, range_Coefficients)/sum(va
Thomas
ASKER
a screen shot would be helpful, huh? :-p
excel.JPG
excel.JPG
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks nutsch, I put divided by C12 as it is division by 100 as per the screenshot.
Screenshot is 100%, 100%=1.
:)
ASKER
My boss was very happy with those results and ended up with a 100 on his homework. Thanks to you guys I have earned several brownie points :D He stated that while dhiraj05 provided very good insight, it was nutsch's solution that proved to be more complete (in his eyes) I am very ignorant when it comes to Excel and don't even understand the question that was posed, so I would like to ask you both how you would like the 500 points divvied up.
glad that I could be of any help :).. points distribution is up to you.
Likewise, just close it now and you'll make me a genius.
Thomas
Thomas