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

[baidya91]

[TABLE="width: 1026"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]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?



















[/TD]
[TD]51[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD]45[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD]63[/TD]
[TD]B+[/TD]
[TD][/TD]
[TD][/TD]
[TD]46[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD]52[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]59[/TD]
[TD]F[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.