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

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>

 

[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