Limit sum to Top 2.

  • Thread starter Thread starter Krappo
  • Start date Start date
K

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)
 
Krappo said:
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.
Click to expand...

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