Calculate Electricity Cost by Rig
I need to sum 'KWh Cost' where Rig ID is 'Antminer-S19' and Month is 'November'.
=SUMIFS(E2:E8,B2:B8,"Antminer-S19",C2:C8,"November") How it works: The SUMIFS function is used to sum values in a range that meet multiple criteria. In this scenario, it sums the 'KWh Cost' (E2:E8) only for rows where the 'Rig ID' (B2:B8) is exactly "Antminer-S19" AND the 'Month' (C2:C8) is exactly "November". This allows the Bitcoin Miner to precisely track costs for specific equipment during specific periods.
Data Setup
| Date | Rig ID | Month | KWh Consumed | KWh Cost |
|---|---|---|---|---|
| 2023-11-01 | Antminer-S19 | November | 100 | 12.50 |
| 2023-11-02 | Antminer-S19 | November | 105 | 13.13 |
| 2023-11-03 | Whatsminer-M30S | November | 90 | 11.25 |
| 2023-11-04 | Antminer-S19 | December | 110 | 13.75 |
| 2023-11-05 | Antminer-S19 | November | 95 | 11.88 |
| 2023-12-01 | Antminer-S19 | December | 100 | 12.50 |
| 2023-11-06 | Whatsminer-M30S | November | 92 | 11.50 |
Step-by-Step Guide
Identify the range containing the values you want to sum, which is 'KWh Cost' (Column E).
Identify the first criteria range, 'Rig ID' (Column B), and its corresponding criteria, "Antminer-S19".
Identify the second criteria range, 'Month' (Column C), and its corresponding criteria, "November".
Enter the SUMIFS function: Start with '=SUMIFS(', then select the sum range (E2:E8), followed by the first criteria range (B2:B8) and its criteria ("Antminer-S19"), and finally the second criteria range (C2:C8) and its criteria ("November").
Close the parenthesis and press Enter to get the total electricity cost.