How to find the maximum value that is obtained in the sum of n numbers in Excel?
<p>I have a list of numbers, of which any <code>n</code> number of numbers can be taken and summed up.</p>

<p>For example:</p>

<p>In the image below is an example senario, where the choice of answering '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.</p>

<p><img src="https://i.stack.imgur.com/5TsPe.jpg" alt="Image"></p>

<p>I need to find the maximum value obtained.</p>

<p>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</p>

<p><img src="https://i.stack.imgur.com/SlZWi.jpg" alt="Image"></p>