Use Formula for Cell Reference - Example: Sliding Window Average

Is it possible to use a formula in a cell reference? For example, 'sum of the last 12 cells'. So the cell address might be =SUM($C$(ROW(THIS.CELL)-12):C19) I know this gets into relative cells, but...