1

Topic: Spreadsheet

How do you get the total to appear automatically to the average column?

Re: Spreadsheet

You do not want a total in the average column. You want the average to appear at the right/bottom of an average row/column.

Formula for average "=average(starting cell:ending cell)"
Formula for total "=sum(starting cell:ending cell)"

Drag the + pointer to autofill the remaining cells in which the formula will appear.