I entered it in C1. The array formulas is set correctly. I used exactly the formula you posted but then changed the $A$1:$A$7.