Two formulae to calculate the sum of top 3 cells for a category?

[billj]

Dear all,

I used two different formulae to calculate the sum of top 3 cells for a category. Text values or errors are both taken into account. The two formulae used are:

=SUM(LARGE(IF(A2:A11="Medium",IF(ISNUMBER(B2:B11),B2:B11,""),""),ROW(INDIRECT(("1:3")))),0)

=SUM(IF((A2:A11="Medium")*(RANK(B2:B11,B2:B11)<=3),B2:B11,0))

The first one works well, but the second one does not. I tried to repair the second one, but failed

I attached the sample here. Can you please have a look to modify formula 2?

Thanks a lot in advance.