Excel formula in numbers

Numbers does not support most Excel array formulas (identifiable by the presence of 'curly brackets' ( {} ).

LARGE, in Number accepts only a single number for its second argument, so you'll need an iteration of the LARGE function for each of the values you want to include in the sum:

SUM(LARGE(C2:T2,1),LARGE(C2:T2,2),LARGE(C2:T2,3),LARGE(C2:T2,4),LARGE(C2:T2,5),LARGE(C2:T2,6),LARGE(C2:T2,7),LARGE(C2:T2,8))

You can also choose to build a list of the numbers to be included in a single column array in a separate column, or row on the same or a different table, Then SUM that one dinension array with a second formula on the original table.

The formula on the right is entered in A2 of the single column table on the right, Table 2, and is filled down to row 9.

The basic SUM formula on the left is in cell B3 of the original table.

Regards,

Barry

*Almost a direct equivalent. As with the original formula you'll want to consider how you want to handle any exactly equivalent values.

SG

A direct equivalent to your Excel formula =SUM(LARGE(C2:T2,{1,2,3,4,5,6,7,8})) would be this in Numbers:

=SUMIFS(C2:T2,C2:T2,">="&LARGE(C2:T2,8))

That will work in Excel too, so you don't really need to use an array formula there if you don't want to.

SG

The logic is straightforward. The formula simply uses the SUMIFS function to sum up only the values in C2:T2 that are greater than or equal to the eighth largest value in that range.

It’s a good approach unless, of course, you enjoy typing long formulas.😀 As you can see, in this case you do not need an iteration of the LARGE function for each of the values you want to include in your sum.

You can read more about SUMIFS and SUMIF and see examples of how they are used at Help > Formulas and Functions Help in your menu. They are commonly used and very useful functions well worth adding to your toolbox.

SG