David, what Mike is saying is that you would have to find a way to put all the values in a single row, as "we can only do expressions on the same horizontal row".
The values to average would have to come from different columns within the same row, not the same column from different rows...