Hi, I´m looking for some clarification on something if someone could help,
Normally, to find a weighted avg I use a sumproduct and voila..
This time my values are %´s and I have a count of the number of times they appear.. the sumproduct result is strange. Please see the attached spreadsheet.
Many thanks for looking
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Probably:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Maybe
=SUMPRODUCT(A2:A18,B2:B18)/SUM(B2:B18)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks