Generate permutations from a table that satisfy criteria

Hi everyone,
I would like to generate a set of permutations that are unique and satisfy a criteria from a table.
I have 8 classes and in future there will always be 8 classes for the week. Each class has a different number of students. This can range from 3 up to say 20 students for each class.
I need to pick a student from each class and add their scores together. If the total score falls with a set range, I need to have the permutation copied down that represents each of those students.
So for the example attached, I have 111.2 millions possible permutations. I only want to record the permutation when the total score of the 8 students (1 from each class) is between 10 and -20 points in total. Though this overall score will need to be changed. So at times I might choose (-5 and -40) or (30 and 22).
I would need to calculate say aaaaaaaa, aaaaaaab, aaaaaaac....
And running through all possible scenarios, the permutations I need recorded would start at aaaaaaah, aaaaaabg, aaaaaabh, aaaaaacf - as seen in the attachment in column U.
Preferrably I would have all the possible permutations in the one column.
If this is not possible with excel, what other programs could I use?
I really appreciate all the help and wish you all a fantastic day.

class score results permutations.xlsx