Lessons › Excel & Google Sheets
Excel & Google Sheets lesson
AVERAGE, MIN, MAX
AVERAGE adds the five days and divides by five. MIN and MAX find the lowest and highest in the same way.
Try this lesson free →Example
The average is the total divided by the number of days. One formula does both:
=AVERAGE(D2:D6)| Day | Product | Qty | Revenue |
|---|---|---|---|
| Mon | Phone case | 12 | 96 |
| Tue | Charger | 8 | 120 |
| Wed | Earbuds | 5 | 175 |
| Thu | Phone case | 15 | 120 |
| Fri | Screen guard | 20 | 100 |
| Average | |||
| Lowest | |||
| Highest |
Key points
AVERAGEThe typical value: the total divided by how many there are.
MINThe smallest number in the range.
MAXThe biggest number in the range.
Same shape as SUM: =MAX(D2:D6). Only the function name changes.
Practice
1. In D8, find the lowest revenue of the week.
=MIN(D2:D6)2. In D9, find the highest revenue of the week.
=MAX(D2:D6)3. In C7, find the average quantity sold per day.
=AVERAGE(C2:C6)4. In C9, find the most items sold in one day.
=MAX(C2:C6)5. In C8, find the fewest items sold in one day.
=MIN(C2:C6)Learn it by doing. This lesson is a short hands-on level on Bampaa: see it work, then build and write it yourself, with instant feedback.
Try this lesson free →