This graphic illustrates how to have column 7 to show the average of the amounts in columns 1 through 6.