BeginnerGeneral officeAbout 4 minutes
Sample data
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Item | Qty | Unit price | Region | Date |
| 2 | Pen | 10 | 1.5 | North | 2025-01-15 |
| 3 | Notebook | 5 | 12 | South | 2025-02-03 |
| 4 | Pen | 20 | 1.5 | South | 2025-02-28 |
| 5 | Stapler | 2 | 40 | North | 2025-03-10 |
| 6 | Folder | 15 | 3.25 | East | 2025-03-22 |
| 7 | Notebook | 8 | 12 | East | 2025-04-05 |
| 8 | Pen | 12 | 1.5 | North | 2025-04-18 |
| 9 | Marker | 30 | 2 | South | 2025-05-02 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Click an empty cell below your data, or any empty cell you like.
Type the total. SUM adds every number in the range B2:B9.
Result
Now the average order size.
Result
Find the biggest and smallest order.
Result
And the smallest.
Result
Count how many orders there are.
Result
What to remember
Five functions cover most of what people need in a first spreadsheet: SUM, AVERAGE, MAX, MIN and COUNT.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.