Another question if you don't mind:

If I wrote the functions for 15 columns (15 subjects for grade 10) in the worksheet but another grade, let's say grade 8, has 12 subjects, is there a way to cancel (#REF!) error and solve it automatically without correction each function?
i.e. how to make a dynamic function?

Appreciate it.