| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weighted Average of positive and negative %
I have the following numbers and corresponding growth rates:
A B 1 4197 7.90% 2 4114 8.30% 3 1885 0.50% 4 624 10.50% 5 1051 -3.30% 6 216 16.20% My problem is the negative growth rate of -3.30% - I want to calculate the weighted average growth rate and get the following results for the respective formulas: =SUMPRODUCT(A1:A6,B1:B6)/SUM(A1:A6) = 6.2% =SUMPRODUCT(A1:A6,ABS(B1:B6))/SUM(A1:A6) = 6.8% Do I need the ABS() function or not? Which would be the correct result? Thanks! JK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add sequences of positive then negative numbers | Excel Discussion (Misc queries) | |||
| I Need a formula to evaluate a cell with + or - values | Excel Worksheet Functions | |||
| Formula to make Negative Values Positive & Positive Values Negative? | Excel Discussion (Misc queries) | |||
| change cell from negative to positive | Excel Discussion (Misc queries) | |||
| How can I change positive numbers to negative, i.e. change 50 to - | Excel Discussion (Misc queries) | |||
Threaded Mode
