Sum a column based on an IF Statement

[danniaus]

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


[TABLE="class: grid, width: 420"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]NMI Acquisition or Renewal[/TD]
[TD]Annual Peak KWh*[/TD]
[TD]NMI/MIRN State*[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]180,000[/TD]
[TD]VIC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]180,000[/TD]
[TD]VIC[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]200000[/TD]
[TD]QLD[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD="align: right"]300000[/TD]
[TD]SA[/TD]
[/TR]
</tbody>[/TABLE]

 

[AhoyNC]

Use SUMIF.

Excel Workbook
	A	B	C	D	E	F
1	NMI Acquisition or Renewal	Annual Peak KWh*	NMI/MIRN State*		State	VIC
2		180,000	VIC		Total	360000
3		180,000	VIC
4		200000	QLD
5		300000	SA
Sheet

 

[PaddyD]

or use a pivot table