← Excel Sales Reporting
Lesson 2 of 4
Calculate conditional totals
Use conditions before summing sales.
Do the work
- The declared sales are East 120, East 100, West 180 and West 120.
- A conditional total includes only the matching region.
- Write a two-row summary; do not include raw rows.
See the method
SUMIF tests a region range and sums its amount range.
Read every demonstration step
- SUMIF tests a region range and sums its amount range.
- East totals 220; West totals 300.
- Check that both groups sum to 520.
Practice independently
Take it further
Try SUMIF on a scratch grid using ranges from the same rows.