SheetsdrillAverage order value
A Google Sheets formula exercise from Sheetsdrill. Solve it with a formula bar on a live sheet in your browser, and it is checked the moment you submit.
The task
Eight orders came in today. Put the average order amount in E2.
What this exercise teaches
AVERAGE adds the numbers and divides by how many there are. Empty cells and text are skipped.
A hint if you get stuck
There is a function named after exactly what you want. Give it the range of amounts.
Try it now, no account needed
This exercise is free. Open it on the practice page, solve it, and get instant feedback with a hint and a worked solution after two tries.
Open this exercise