Formula in F3 and down is an ARRAY formula. Read how to use these formulaw in the link that i provide.

-- Array(CSE) { }, formulae are confirmed with Control+Shift+Enter.
Not just Enter.