The formula I typed is
=SUMPRODUCT(E2:E17,D2:D17/SUM(D2:D17))
Works fine but gives me a lowered average because it counts blank cells as a 0%.
I want it to count only those cells that have the % value in them.
Update: thanks for the quick reply; I've uploaded the file.
Bookmarks