You still need the Longre idiom Debra invokes...

=SUMPRODUCT(SUBTOTAL(3,OFFSET(B8:B250,ROW(B8:B250)-MIN(ROW(B8:B250)),,1)),
B8:B250,D8:D250)/SUBTOTAL(9,B8:B250)

Lisa wrote:
Debra, I'm sorry, I did not put the full formula that I am having a
problem with. It is:
SUMPRODUCT(B8:B250,D8:D250)/SUM(B8:B250). I want this formula to
recalculate and give me the result of the visible cells only when I
filter. How would I modify the formula you gave above to work with
this? thanks for your help.