Hi, this my problem.
I have an SUMPRODUCT working on a formula but I need to make it change dynamicaly with filters.
This is the part of my formula: SUMPRODUCT(($H9:$H5001)*(M9:M5001<>""))
All the formula for the context, it's calculating an weight average:
=SUMPRODUCT((SUBTOTAL(9;OFFSET($H9:$H5001;ROW($H9:$H5001)-MIN(ROW($H9:$H5001));;1)))*(M9:M5001))/SUMPRODUCT(($H9:$H5001)*(M9:M5001<>""))
Thanks by advance.
Bookmarks