In Sheets, type the formula for the mean of the amounts in D2:D13. space to flip In Sheets, type the formula for the mean of the amounts in D2:D13. Answer =AVERAGE(D2:D13) 6140 / 12 = 511.67. Text cells and blanks in the range are skipped silently.