Google's take on array formulas

[iliace]

http://googledocs.blogspot.com/2007/07/array-formulas-without-ctrl-shift-enter.html

Not sure how I feel about this... I think this makes it more obscure.

 

[NateO]

It doesn't really add any transparency, imo. I wonder if those dudes visit this site?

I noticed they fixed Sumproduct() to some extent. Speaking of obscure, are they document that thing, ever?

 

[iliace]

The kind of usage you're talking about, mostly what people use sumproduct for, I've only seen mentioned in the recent article on optimizing calculation speed. It discussed how SUMPRODUCT() is usually faster than its {SUM()} equivalent, and other options. Beyond that, nothing from MS.

 

[NateO]

Microsoft doesn't really document array functionality... I've only seen 3rd party testimony.

Still, I'm not convinced that it's that obscure, there are plenty of members here who know plenty about it, and a ton of posts on the subject.