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" 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" 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.  |