Array formula issue

[Craig]

I saw this example of an array formula that sums the 3
largest values in a list. I understand how you enter
arrays (ctrl-shift-enter). What I don't understand is how
whoever did this got the curly braces around just the
{1,2,3} values, and not the whole formula. Because if you
try to type this formula into Excel, you'll get an error
message.

=SUM(LARGE(A1:A100,{1,2,3}))

 

[Frank Kabel]

Hi
in this case no array enter required. Just enter this formulas 'as-is'
with the curly brackets inside and just hit ENTER

 

[Alan]

I don't think this needs to be array entered, the error message probably
arises if there are less than three values in A1:A100
This can be avoided by modifying it to
=IF(SUM(A1:A100)<>0,SUM(LARGE(A1:A100,{1,2,3})),0)
Regards,

 

[Alan]

Sorry that will still give an error meaasge,
=IF(COUNTA(A1:A100)>=3,SUM(LARGE(A1:A100,{1,2,3})),0)
Apologies,

 

[JE McGimpsey]

I don't get an error message when I array-enter your formula.

The inner brackets are typed, just as you have.

 

[Craig]

I guess I should have tried entering the formula by typing
the curly brackets.

Thanks for all the help!