1

I want to be able to average, or other function, over a subset of the cells in a row.  The number of cells I want to include is specifiied in a separate cell.

 

In Excel, I accomplished this with OFFSET.  I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and