ROW Function Criteria Not Accepted

Hi everyone,   I'm trying to get the ROW() function to accept the values written in different cells.   The following formula works and yields an array: =ROW(1:6)     However, I would like to ...