I am new to Numbers and have an Excel Spreadsheet that I've used previously that calculates the best 4 scores from golfers over a 10 week period. In Excel I used =sum(LARGE[e2:n2,{1,2,3,4}]) but when I use it in Numbers I get a Syntax Error message. Is there anyone who can help me convert the Excel formula so that it works in Numbers.
iMac, iOS 8
Numbers does not use excels array functions so this will probably work:
=SUM(LARGE(E2:N2, 1), LARGE(E2:N2, 2), LARGE(E2:N2, 3), LARGE(E2:N2, 4))
Numbers does not use excels array functions so this will probably work:
=SUM(LARGE(E2:N2, 1), LARGE(E2:N2, 2), LARGE(E2:N2, 3), LARGE(E2:N2, 4))
Thank you very much Wayne, this has worked, after populating all the cells for future weeks with zeros.
Converting Excel formulas in Numbers
