BTW the documentation on array formulas isn't that good, and I have never seen a really good explanation of how they work. You generally get an intuition for it after seeing about 50 examples, but I still can't even write a good explanation myself.