hi my question is
for internal assessment test
no of questions given =8
max marks for each question =5 {for theory subjects} and students should answer any 5 questions but some students will answer more than 5 questions..for this i have written a formula
=SUMPRODUCT(LARGE((F9:M9>=0)*F9:M9,{1,2,3,4,5}))
using this formula i got expected result i.e within 25 marks
NOW
for some mathematical subjects the allocation of marks will differ like
Q1=5, Q2=6, Q3=10, Q4=7, Q5=12.5, Q6=10, Q7=9, Q8=10
what is the formula i will have to write in excel for this type of problem, so that i should get the total of 25 marks no matter which ever and how many questions (i.e within 8 questions) the student is going to answer.