" wrote:

"cursednomore" wrote:
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?

I would write a VBA subroutine. But ....

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

The sum of which possible combinations? Combinations of 7
taking only one from each category? Combinations of 7 taking
one or more from each category? Something else altogether?


Sorry for not being clearer, 1 possible choice from each category.