Sum Weight for Shipping Quote
I need to sum the 'Weight' of all items where Order ID is '10234' to calculate shipping costs.
=SUMIFS(C2:C6, A2:A6, "10234") How it works: The SUMIFS function is used to sum values in a range that meet multiple criteria. In this scenario, it sums all values in the 'Weight (kg)' column (C2:C6) only for rows where the corresponding 'Order ID' in column A (A2:A6) exactly matches '10234'. This provides the total weight for a specific order, crucial for calculating accurate shipping costs.
Data Setup
| Order ID | Item | Weight (kg) | Quantity |
|---|---|---|---|
| 10234 | Laptop | 2.5 | 1 |
| 10235 | Mouse | 0.1 | 2 |
| 10234 | Keyboard | 0.8 | 1 |
| 10236 | Monitor | 4.0 | 1 |
| 10234 | Webcam | 0.2 | 1 |
Step-by-Step Guide
Organize your data with 'Order ID' in one column (e.g., Column A) and 'Weight (kg)' in another (e.g., Column C).
Identify the range containing the values you want to sum (the 'Weight (kg)' column, e.g., C2:C6).
Identify the range containing the criteria (the 'Order ID' column, e.g., A2:A6).
Specify the criteria value, which is the specific Order ID you're looking for (e.g., "10234").
Enter the SUMIFS formula into a cell: `=SUMIFS(C2:C6, A2:A6, "10234")`.