Using the SUMIF() function w/ #DIV/0! errors in range

I have literally tried every formula I know of and criteria to ignore the #DIV/0! errors in the sum range, and I can't seem to figure anything out.

Here is my current formula:

=SUMPRODUCT(D5:D16,E5:E16)/SUM(SUMIF(E5:E16,">"&0))

I'm doing a weighted average of two columns which contain #DIV/0! errors in them (because they are yet to be calculated) and I want to add up the column and ignore or return #DIV/0! errors as zero. Both column D and E contain #DIV/0! errors. I'm not quite sure what is the best method for ignoring errors using the sumproduct formula. I've tried 4 different methods and none have worked for me.

What is the best approach to this? What am I doing wrong?