Update the output cells so that each student's invalid marks cell displays the count of invalid marks for that student for classes they took. If a cell is blank it means the student didn't take that class. If the mark is non-numeric it means it's invalid. See Examples
Your solution should use cell references so it updates automatically if the input cells change values.
This cell cannot be edited
Update the output cells so that each student's invalid marks cell displays the count of invalid marks for that student for classes they took. If a cell is blank it means the student didn't take that class. If the mark is non-numeric it means it's invalid.