Average order size

Beginner← PreviousSkip →
Exercise 2 of 11AVERAGE

On average, how many units were sold per order?

Write your formula in the green cell, I2.

Basics & math

Total revenueAverage order sizeLargest orderSmallest orderCount the ordersCount text cellsAdd two cellsRevenue per unitPercentage changeRound to the nearest 10Share of the total
q1-orders.xlsx
fx
1DateRegionRepProductUnitsRevenue
2Jan 4, 2026NorthAvaLaptop3$3,600.00Avg units
3Jan 9, 2026SouthLeoMonitor5$1,250.00
4Jan 15, 2026NorthMayaLaptop2$2,400.00
5Jan 22, 2026EastSamKeyboard12$720.00
6Feb 3, 2026WestZoeMonitor4$1,000.00
7Feb 11, 2026NorthAvaKeyboard8$480.00
8Feb 19, 2026SouthIvyLaptop4$4,800.00
9Feb 27, 2026EastSamMonitor6$1,500.00
10Mar 6, 2026WestNoahLaptop1$1,200.00
11Mar 14, 2026NorthMayaMonitor7$1,750.00
12
13

Click a cell to add it to your formula, drag to select a range, or click a column letter for the whole column.

About basics & math in Excel

Start here if you're new to Excel formulas. These exercises teach you how cell references and ranges work, and how to add up, average, count and round numbers with SUM, AVERAGE, MAX, COUNT and ROUND.

Functions you can use here

  • SUM(number1, [number2], …)
  • AVERAGE(number1, [number2], …)
  • MAX(number1, [number2], …)
  • COUNT(value1, [value2], …)
  • ROUND(number, num_digits)

More basics & math exercises

  1. 1.Total revenue
  2. 2.Average order size
  3. 3.Largest orderPremium
  4. 4.Smallest orderPremium
  5. 5.Count the ordersPremium
  6. 6.Count text cellsPremium
  7. 7.Add two cellsPremium
  8. 8.Revenue per unitPremium
  9. 9.Percentage changePremium
  10. 10.Round to the nearest 10Premium
  11. 11.Share of the totalPremium
See the whole topic →