Conditional Sum of cells in a row

[Ron King]

Hi,
I'm using Excel 2002 and would like to know how to do the following:

I have 7 cells in a row in which scores will be entered. I need to compare
the scores and then sum the 4 highest scores to get my total.

example ( each number represents 1 of the 7 cells in my row): 1 2 2 3 0
3 2, producing the result of 10
or 2 2 2 2 2 0 1, producing the result of 8, or 1 1 1 1 1 1 2,
producing the result of 5, etc.

I hope this makes sense. I know its probably simple, but I can't figure out
how to do it. Any help would be greatly appreciated!

Thanks,
Ron

 

[Frank Kabel]

Hi
try
=SUM(LARGE(A1:X1,{1,2,3,4,5}))

 

[Ron King]

Awesome, works like a charm:c) Thank you so much Frank!

Ron