Prev: how to return to full worksheet after filtering a colume?
Next: Calling a .net library from excel
From: nrbrtsn on 8 Mar 2010 15:07
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.
From: L. Howard Kittle on 8 Mar 2010 15:32
Try this,

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

HTH
Regards,
Howard

"nrbrtsn" <nrbrtsn(a)discussions.microsoft.com> wrote in message
news:5E0744A0-3932-466B-AA08-167B3BA85892(a)microsoft.com...
>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.


From: T. Valko on 8 Mar 2010 19:22
Another one...

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

--
Biff
Microsoft Excel MVP


"nrbrtsn" <nrbrtsn(a)discussions.microsoft.com> wrote in message
news:5E0744A0-3932-466B-AA08-167B3BA85892(a)microsoft.com...
>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.


 | 
Pages: 1
Prev: how to return to full worksheet after filtering a colume?
Next: Calling a .net library from excel