Excel: Please do help me find the Maximum value that is obtained in the sum of n numbers : I have a list of numbers, of which any 'n' number of numbers can be taken and summed up.

For example: Please do view the image...

[In the image below is an example senario, where the choice of answereing 'n' questions is given and the max of the sum of the combination of the marks has to be obtained out of the maximum marks.][1]

I need to find the maximum value obtained.

[With reference to the above image, we get the maximum of the sum of any 4 numbers in Q1 and maximum of the sum of any 3 numbers in Q2][2]

Thank you.


  [1]: https://i.stack.imgur.com/5TsPe.jpg
  [2]: https://i.stack.imgur.com/SlZWi.jpg