Discussion Re: Excel formulas and functions in Excel
https://techcommunity.microsoft.com/t5/excel/excel-formulas-and-functions/m-p/305750#M23090
<P>Hi,</P>
<P> </P>
<P>How to sum N largest in the range is here <A href="https://exceljet.net/formula/sum-top-n-values" target="_blank">https://exceljet.net/formula/sum-top-n-values</A>, if with criteria <A href="https://exceljet.net/formula/sum-top-n-values-with-criteria" target="_blank">https://exceljet.net/formula/sum-top-n-values-with-criteria</A></P>Fri, 21 Dec 2018 11:22:07 GMTSergei Baklan2018-12-21T11:22:07ZExcel formulas and functions
https://techcommunity.microsoft.com/t5/excel/excel-formulas-and-functions/m-p/305697#M23089
Ciao to everybody. I wonder if a function (or other method) exists to calculate the sum of the e.g. 5 hyghest values in the rows of a data base where in the columns the the tournements of a golf circuit are listed and in the rows the results of each player are listed. Not necessarily all players have a result in each tournement. I need an additional column where the sum of the best 5 results of each player is fitted, in one shot. I have done it one by one by a macro, but players may be more tha 100 and tournements more the 30. Thank you for helpFri, 21 Dec 2018 09:35:52 GMThttps://techcommunity.microsoft.com/t5/excel/excel-formulas-and-functions/m-p/305697#M23089ctirelli2018-12-21T09:35:52ZRe: Excel formulas and functions
https://techcommunity.microsoft.com/t5/excel/excel-formulas-and-functions/m-p/305750#M23090
<P>Hi,</P>
<P> </P>
<P>How to sum N largest in the range is here <A href="https://exceljet.net/formula/sum-top-n-values" target="_blank">https://exceljet.net/formula/sum-top-n-values</A>, if with criteria <A href="https://exceljet.net/formula/sum-top-n-values-with-criteria" target="_blank">https://exceljet.net/formula/sum-top-n-values-with-criteria</A></P>Fri, 21 Dec 2018 11:22:07 GMThttps://techcommunity.microsoft.com/t5/excel/excel-formulas-and-functions/m-p/305750#M23090Sergei Baklan2018-12-21T11:22:07Z