| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show weighted average value after filter.
Problem.
Using the SUBTOTAL(1,D5:D13) will return the simple average after I have filtered a list of values in colum d or another colum. However I want to show the Weighted average correctly after a filter is applied. I.E Currently I use this, =SUMPRODUCT(D5:D12,$J$5:$J$12)/SUM($J$5:$J$12) but the value will not change if I filter and of the colums. Hope someone can help and thatnks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| weighted average in pivot table | Excel Discussion (Misc queries) | |||
| Why does my advance filter only show one record? | Excel Discussion (Misc queries) | |||
| Weighted Average | Excel Discussion (Misc queries) | |||
| Excel Auto Filter: WHY'S SORT @ TOP OF LIST? WHEN I KEY TO "SHOW . | Excel Worksheet Functions | |||
| What is the formula for weighted average? | Excel Worksheet Functions | |||
Threaded Mode
