Sum Revenue by Product Category
I need to sum 'Total Sales' where Category is 'Electronics' and Region is 'North America'.
=SUMIFS(E2:E9, C2:C9, "Electronics", D2:D9, "North America") How it works: The SUMIFS function allows you to sum values in a range that meet multiple criteria simultaneously. In this scenario, it sums the 'Total Sales' (E2:E9) only for rows where the 'Category' (C2:C9) is exactly 'Electronics' AND the 'Region' (D2:D9) is exactly 'North America'. This provides a precise revenue figure for a specific segment of your e-commerce business, enabling targeted analysis and decision-making.
Data Setup
| Order ID | Product Name | Category | Region | Total Sales |
|---|---|---|---|---|
| 1001 | Laptop Pro | Electronics | North America | 1200 |
| 1002 | Smartphone X | Electronics | Europe | 800 |
| 1003 | Desk Chair | Furniture | North America | 300 |
| 1004 | Headphones Z | Electronics | North America | 150 |
| 1005 | Coffee Maker | Home Goods | Asia | 100 |
| 1006 | Tablet Mini | Electronics | North America | 400 |
| 1007 | Gaming PC | Electronics | Europe | 1500 |
| 1008 | Dining Table | Furniture | North America | 600 |
Step-by-Step Guide
Identify the range containing the values you want to sum: This is the 'Total Sales' column (E2:E9).
Identify the first criteria range: This is the 'Category' column (C2:C9).
Specify the first criteria: "Electronics".
Identify the second criteria range: This is the 'Region' column (D2:D9).
Specify the second criteria: "North America".
Combine these into the SUMIFS formula: `=SUMIFS(E2:E9, C2:C9, "Electronics", D2:D9, "North America")`.
Enter the formula into a cell (e.g., F2) and press Enter.