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