| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
N Harkawat wrote...
=AVERAGE(IF(A1:A6<0,(B1:B6)*(A1:A6))) array entered (ctrl+shift+enter) .... This is wrong. Given 1 and 9 in A1 and A2 with A3:A6 blank, 1 and 2 in B1 and B2, B3:B6 irrelevant. The weighted average of 1 and 2 with respective weights 1 and 9 should be 1.9 [(1 * 1 + 9 * 2) / (1 + 9)]. The formula above gives 9.5. Do you know what a weighted average is? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted average in pivot table | Excel Discussion (Misc queries) | |||
| Can you calculate "weighted average cost of capital? | Excel Discussion (Misc queries) | |||
| Show weighted average value after filter. | Excel Worksheet Functions | |||
| Weighted Average | Excel Discussion (Misc queries) | |||
| What is the formula for weighted average? | Excel Worksheet Functions | |||
Threaded Mode
