← 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.
Practice independently
Take it further
Try SUMIF on a scratch grid using ranges from the same rows.