Lab › Formulas & Functions › Orders and Sales by Region
Orders and Sales by Region: Excel Lab
Lab 12 · IntermediateCOUNTIFSUMIF$ absolute reference
The task: Count the orders and add the sales for each region.
1 Watch how it is done
Step 1: Count orders per region
=COUNTIF($B$4:$B$13,E4)- Click F4.
- Type =COUNTIF($B$4:$B$13,E4) and press Enter.
- Drag the fill handle down to F7.
Step 2: Add sales per region
=SUMIF($B$4:$B$13,E4,$C$4:$C$13)- Click G4.
- Type =SUMIF($B$4:$B$13,E4,$C$4:$C$13) and press Enter.
- Drag the fill handle down to G7.
2 Your turn
Download the practice file. It has new numbers. Open it in Excel (or Google Sheets) and do the same steps.
3 Check your answers
Stuck? Download the solution file and compare it with yours.
Next lab: Shop Bill with GST →
Want the theory? Read the Formulas & Functions lessons →
← More Formulas & Functions labs · All lab categories
