Hello
I have the following set of data
I would like to like to do the following:
Total the values in Annual Peak KWh* for each state so e.g
There are 2 rows for VIC with 180,000 in each row so the total would be 360,000
1 row for QLD = 200000
What is the formula to create to do that for each state?
Any help appreciated
<colgroup><col><col><col></colgroup><tbody>
</tbody>
I have the following set of data
I would like to like to do the following:
Total the values in Annual Peak KWh* for each state so e.g
There are 2 rows for VIC with 180,000 in each row so the total would be 360,000
1 row for QLD = 200000
What is the formula to create to do that for each state?
Any help appreciated
NMI Acquisition or Renewal | Annual Peak KWh* | NMI/MIRN State* |
180,000 | VIC | |
180,000 | VIC | |
200000 | QLD | |
300000 | SA |
<colgroup><col><col><col></colgroup><tbody>
</tbody>