sirnickalot
New Member
- Joined
- Sep 26, 2016
- Messages
- 2
I've thought that the new =maxifs() function could help me here but I do not have access to it yet in my version of excel.
Basically I have a very large data set from which I need to sum some specific values based on a number of criteria. I've used =sumifs() until now, but every so often there are duplicates which cause double or even triple counting and skews the end result.
For example:
<tbody>
</tbody>
I would be looking for the value in column K associated with "Total KWH" for this date, location, account, meter, etc. but would only want the value 24720 returned once.
Basically I have a very large data set from which I need to sum some specific values based on a number of criteria. I've used =sumifs() until now, but every so often there are duplicates which cause double or even triple counting and skews the end result.
For example:
| A | B | C | D | E | F | G | H | I | J | K | L |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | All Other Applicable ESS Riders USD | 0 | 193.97 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Total KWH | 24720 | 0 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Fuel USD | 0 | 594.76 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Transmission Demand Chg USD | 0 | 98.81 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Dist Serv Demand Charge USD | 47.2 | 0 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | All Applicable Distribution Riders USD | 0 | 13.11 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Dist Serv Demand Charge USD | 0 | 1.98 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Dist Serv Demand Charge USD | 0 | 169.8 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Sales and Use Surcharge USD | 0 | 15.08 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Total KWH | 24720 | 0 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Electricity Supply KWH | 0 | 631.85 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Basic Customer Charge USD | 0 | 22.58 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Late Payment Charge USD | 0 | 7.76 |
| DV | SPID | Location 1 | Account 1 | Meter 1 | Tariff 1 | 11/19/2015 | 12/21/2015 | 12/23/2015 | Total KWH | 24720 | 34.14 |
<tbody>
</tbody>
I would be looking for the value in column K associated with "Total KWH" for this date, location, account, meter, etc. but would only want the value 24720 returned once.
