One way


=SUMPRODUCT(--($D$5:$D$12),--($J$5:$J$12),(SUBTOTAL(3,OFFSET($J$5,ROW($J$5:$J$1 2)-MIN(ROW($J$5:$J$12)),,))))/SUBTOTAL(9,$J$5:$J$12)

--
Regards,

Peo Sjoblom


"BillC" wrote in message
...
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.