Weighted Average without blanks

Hello, I need some help building a formula for the attached spreadsheet. In cell F37 I need to populate the weighted average which it currently does. However, it is taking into account the blank cells so it throws my average off. I've seen some previous postings that give solutions but they don't seem to work with my given scenario.

Here is the formula that is being used - =-SUMPRODUCT('KPI Results'!$K$61:$K$88,'KPI Results'!$B$61:$B$88,-(NOT(ISBLANK(F8:F35))))

Any help would be appreciated!

Thanks!

Why don't you just use the simple average formula? It does not take blanks into the equation. =average($K$61:$K$88) did not take all of those blanks into the equation.