Hi ChemistB,

Not sure why MS designed it so, but only with a function_num parameter of 14 and above will AGGREGATE accept arrays (including those, as in your example, which are derived 'in-formula' via some other construction).

Regards