Sum Refrigerant Used by Unit Type
I need to sum the total pounds of 'Freon' used where Unit Type is 'Commercial AC'.
=SUMIFS(E2:E8, C2:C8, "Commercial AC", D2:D8, "Freon") How it works: The SUMIFS function is ideal for summing values based on multiple conditions. Here, it instructs Excel to look at the 'Pounds Used (lbs)' column (E2:E8) and sum only those values where the corresponding 'Unit Type' (C2:C8) is exactly 'Commercial AC' AND the 'Refrigerant Type' (D2:D8) is exactly 'Freon'. This provides a precise total for specific refrigerant usage across a particular category of units, crucial for inventory management and regulatory compliance for an HVAC Tech.
Data Setup
| Date | Unit ID | Unit Type | Refrigerant Type | Pounds Used (lbs) |
|---|---|---|---|---|
| 2023-01-15 | U001 | Commercial AC | Freon | 10 |
| 2023-01-16 | U002 | Residential Split | R-410A | 5 |
| 2023-01-17 | U003 | Commercial AC | Freon | 15 |
| 2023-01-18 | U004 | Commercial AC | R-410A | 8 |
| 2023-01-19 | U005 | Residential Package | Freon | 3 |
| 2023-01-20 | U006 | Commercial AC | Freon | 12 |
| 2023-01-21 | U007 | Residential Split | Freon | 7 |
Step-by-Step Guide
Open your Excel spreadsheet containing your refrigerant usage data.
Identify the column that contains the 'Pounds Used (lbs)' (e.g., Column E). This will be your 'sum_range'.
Identify the column that contains the 'Unit Type' (e.g., Column C). This will be your first 'criteria_range'.
Identify the column that contains the 'Refrigerant Type' (e.g., Column D). This will be your second 'criteria_range'.
In an empty cell where you want the result, type the formula: `=SUMIFS(E2:E8, C2:C8, "Commercial AC", D2:D8, "Freon")`
Press Enter to see the total pounds of Freon used specifically for Commercial AC units.