Excluding N/A in calculation for weighted scores

[ChillM94]

Good day I am building a database for student results. The results entered is a % out of 100. I want to convert it into a score out of its weighted value. Then calculate the average of a semester. As we use N/A or NA where needed, I need a formula that will exclude the text but still include 0% in the calculation as this lowers overall grades.
For the Average calculation I am using formula 1 below that works for both criteria above but I need this formula to now calculate a weighted score per cell.

1. =ROUND(IF(NOT(ISTEXT(E6:H6)),AVERAGE(E6:H6)),5)

I tried calculating the weighted score first but the formula returns #VALUE! if N/A or N/A is an input in the cell.

2. ROUND(IF(NOT(ISTEXT(E5:E6)),(E6*100)*E$5),0)

Any suggestions would be greatly appreciated.
Thanks

 

[Zot]

If you want to suppress any error, you can use IFERROR

=IFERROR(ROUND(IF(NOT(ISTEXT(E6:H6)),AVERAGE(E6:H6)),5),"")

IF any error including N/A, the result will be just blank "", otherwise the formula is executed.

 

[ChillM94]

Working perfectly. Thank you very much.