Ignore blanks formula not giving correct average based on weights

Hello there,

I got help from someone in this forum a couple weeks ago about a formula that ignored blanks and provided grades even when all activities/assignments/tests were not completed (cells were blank) and the formula worked in the original spreadsheet but when I transferred the formula to a gradebook with more columns and weights the grade for each category was incorrect (Projects, Assignments, Tests). As you can see in the attached spreadsheet, in cell BN6 I should be getting 19.15 but the result is 17.82 and in cell BR6 the result should be 20.88 and I'm getting 25.06. The only row giving the correct grade is BW. I've been trying to figure out the problem for days and can't pin point the issue. Any help you can provide will be greatly appreciated. Thank you!