Location reference is not valid because the cells are not all in the same column or row. Select cells that are all in a single ...