The below question are unanswered in excel in topic 'Counting unique values in excel using sumproduct:

Q2. How many subjects did Suresh appeared?  
Q3. what were the average marks in maths subject?  
Q4. How many marks did each student got?  
Q5. Give grades to each student as :  
  Total Marks Obtained % Grade
  0 TO 50 D
  50 TO 60 C
  60 TO 70 B
  71 and above A
     
Renuka Sethi's image