You don't say which version of MS-Excel you are using. I am using
MS-Office 2003 and it works perfectly in this version.

Though your example is not a good example of an array  formula, good
luck with your learning.