trippypenguin
New Member
 Joined
 Feb 5, 2021
 Messages
 6
 Office Version

 2016
 Platform

 Windows
Hello dear community,
This is my first time posting a question on any online forum  I'm incredibly relieved to have come across a website like this.
I'm trying to find the weighted average(W.A) of fees by different categories (different columns) across rows, by specific range of values within the column.
I figured out how to get the W.A throughout the entire column (pretty straightforward)  I simply had to use sumproduct(column D, column A/B/C) / sum(column A/B/C) *A/B/C as in colulmns A or B or C  different categories
But, within the specific categories (columns A/B/C), I want to model scenarios for different range of values within each category (columns A/B/C).
E.g) Within column A/B/C (e.g. Height/Weight/etc), there would be 1,000 random values ranging from 150 to 210  now I wish to find the weighted average fees for each category by a specific range of height
> such as, weighted average fees for people that are between 150 and 160 cm tall.
How should I approach this? It was incredibly difficult for me to word this particular question concisely enough to post on google to get meaningful searches...
*Below is an example data range  I scraped this from my excel and it shows now but I'm not sure if you guys would be able to see it after I post it. I hope my question is clear!
This is my first time posting a question on any online forum  I'm incredibly relieved to have come across a website like this.
I'm trying to find the weighted average(W.A) of fees by different categories (different columns) across rows, by specific range of values within the column.
I figured out how to get the W.A throughout the entire column (pretty straightforward)  I simply had to use sumproduct(column D, column A/B/C) / sum(column A/B/C) *A/B/C as in colulmns A or B or C  different categories
But, within the specific categories (columns A/B/C), I want to model scenarios for different range of values within each category (columns A/B/C).
E.g) Within column A/B/C (e.g. Height/Weight/etc), there would be 1,000 random values ranging from 150 to 210  now I wish to find the weighted average fees for each category by a specific range of height
> such as, weighted average fees for people that are between 150 and 160 cm tall.
How should I approach this? It was incredibly difficult for me to word this particular question concisely enough to post on google to get meaningful searches...
*Below is an example data range  I scraped this from my excel and it shows now but I'm not sure if you guys would be able to see it after I post it. I hope my question is clear!