Limit sum to Top 2.

[Krappo]

I need a formula to sum cells which limited to
two cells only with highest score **(top 2).

example:

A B C D E
67 68 50 98 70
77 50 77 76 70

which were calculate manually by:

=sum(d1,e1)
=sum(a2,c2)

 

[Paul]

I need a formula to sum cells which limited to
two cells only with highest score **(top 2).

example:

A B C D E
67 68 50 98 70
77 50 77 76 70

which were calculate manually by:

=sum(d1,e1)
=sum(a2,c2)

Thanks in advance.

Krappo.

For row 1:
=SUM(LARGE(A1:E1,{1,2}))
Copy down for row 2 ....

 

[Peo Sjoblom]

One way

=SUMPRODUCT(LARGE(A1:E1,{1,2}))

 

[Bernard Liengme]

Or, simply, LARGE(A1:E1,1)+LARGE(A1:E1,2)
Bernard

 

[J.E. McGimpsey]

another alternative:

=SUM(LARGE(A1:E1,{1,2}))

Or, simply, LARGE(A1:E1,1)+LARGE(A1:E1,2)
Bernard