BeginnerSalesAbout 7 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.
Total Pen quantity with SUMIF.
Result
Total for the South region.
Result
Pens in the South only. SUMIFS handles several conditions.
Result
Total sales value: quantity times unit price, added up.
Result
How many orders were from the North?
Result
Average Pen order size.
Result
What to remember
SUMIF, COUNTIF and AVERAGEIF answer “how much, how many, how big” for any group. Add an S for more than one condition.
Formulas used
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.