Adding selected numbe in a column
Les Golf wrote:
I am using Excel to get results of a competition where there are 100
results of which the top 50 count for each player.
Need the Total of the column to only add the best 50 scores.
Hi Les,
try with this formula:
=SUM(LARGE($A$1:$A$100,ROW($A$1:$A$50)))
array-entered, i.e. you have to press CTRL + SHIFT + ENTER instead of just
ENTER.
Where the results I assume are in $A$1:$A$100, but you can change this
range.
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy
|