HI! I am using the following formula for my grade-book which works great if all cells have a number; however, once a cell is empty it gives me a value error. How can I fix it. Any help will be greatly appreciated.
=IF($J$4="","",(SUM(K5*L5,N5*O5,Q5*R5,T5*U5,W5*X5,Z5*AA5,AC5*AD5)/SUM(L5,O5,R5,U5,X5,AA5,AD5)))
For example: K5 is the grade and L5 is the weight so if all grades and weights are entered it works but if I erase any of the grades it stops working or if I put only the first grade it does not work. In other words, it only works if all the grades are written. Since this is a grade book, I need to give me the result or the new result each time I put a Grade.
Thanks!
Bookmarks