How about this...?
Columns A,B,Q,AA,AD hold the data

=SUM(LARGE((A1,B1,Q1,AA1,AD1),1),LARGE((A1,B1,Q1,AA1,AD1),2),LARGE((A1,B1,Q1,AA1,AD1),3),LARGE((A1,B1,Q1,AA1,AD1),4))
Show your appreciation - Click on the star icon if this post has been helpful