adding largest numbers

[nrbrtsn]

I want to add the largest five numbers in a range, which will change daily.
I have put a condition on to highlight the top five and that is working. I
don't know how to add the largest five numbers since the largest 5 numbers
will change from cell to cell daily. I am assuming you would use a SUMIF,
then range, but how do you write a critieria for the largest five numbers?

Thanks for helping a beginner.

 

[L. Howard Kittle]

Try this,

=SUMPRODUCT(LARGE(A1:A100,{1,2,3,4,5}))

HTH
Regards,
Howard

 

[T. Valko]

Another one...

=SUM(LARGE(A1:A10,{1,2,3,4,5}))