I have 7 categories, each category has 5 possible scores. I want to calculate
the sum of each possible combination. Is there a way to do this in Excel?

My grid looks like this:
JobKnowl 15 12 9 6 3
CallAcc 15 12 9 6 3
CallQual 15 12 9 6 3
JobAcc 5 4 3 2 1
IPSkill 10 8 6 4 2
Attend 20 16 12 8 4
Punct 20 16 12 8 4