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.