Summing top 5 marks in excel excluding those marked 'F'

[baidya91]

Given below is the list of 6 marks with various grades. Now how can I sum top 5 marks excluding that marked "F" in excel?

51

B

45

C

63

B+

46

C

52

B

59

F

<tbody>
</tbody>

 

[admiral100]

BTW , regarding your sample

Entered with Ctrl+Shift+Enter

AK9 =SUM(LARGE(IFERROR(--($G$6:$AJ$8="TOTAL")*--(H9:AJ9 <> "F")*G9:AI9,0),{1,2,3,4,5}))

 

[baidya91]

btw , regarding your sample

entered with ctrl+shift+enter

ak9 =sum(large(iferror(--($g$6:$aj$8="total")*--(h9:aj9 <> "f")*g9:ai9,0),{1,2,3,4,5}))

it works fine. Many many thanks.