Hi all,
Would anyone happen to know if it is possible to basically combine the below with the subtotal function? I am looking to have the formula (weighted avg) adjust based on filtered items in column i. Thank you in advance!
=SUMPRODUCT(C5:C11,F5:F11)/SUM(F5:F11)
Bookmarks