| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sumproduct
I have a list names, dollar amount and %.
I need to calculate the weighted average % for each name, and then rank them in order. Would I use the sumproduct formula? X 100 5.6% Y 200 4.0% Z 300 4.4% X 400 5.0% Z 500 6.0% Z 1000 6.65% X 2000 6.4% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding "OR" to a Sumproduct Formula | Excel Worksheet Functions | |||
| Need help with sumproduct and dynamic ranges | Excel Worksheet Functions | |||
| Can I reference =, <, or > sign in SUMPRODUCT | Excel Discussion (Misc queries) | |||
| Sumproduct function not working | Excel Worksheet Functions | |||
| adding two sumproduct formulas together | Excel Worksheet Functions | |||
Threaded Mode
