I've had problems in the past entering a .FormulaArray reference into a range of cells all at once. They all seemed to take the formula from the first cell in the range and no adjustments occur for relative references.

I had to enter the formula as an array into the first cell, then use a copy method for the rest of the range...AutoFill or Copy/Paste...both work fine.