Any ideas why the formula returns an error? I guess by drag and drop (cut and paste), the N reference is deleted. Unlike in drag and fill (copy and paste) where the values are copied to the N cells.