SUMIF or SUM or COUNTIF

[The Grim Discovery]

Help would be great people.
Could someone point me in the right direction with a formula that would calculate the aggregated Total (Col B) for South Location (Col C)? The answer should be 14.
And if it's not too much, the Total for South Location where the Severity is High? Should b 9.

Thanks bigly
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]ID[/TD]
[TD]Total[/TD]
[TD]Location[/TD]
[TD]Severity[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Case 1[/TD]
[TD]10[/TD]
[TD]East [/TD]
[TD]High[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Case 2[/TD]
[TD]5[/TD]
[TD]South[/TD]
[TD]Medium[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Case 3[/TD]
[TD]8[/TD]
[TD]North[/TD]
[TD]Medium[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Case 4[/TD]
[TD]4[/TD]
[TD]South[/TD]
[TD]High[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Case 5[/TD]
[TD]5[/TD]
[TD]South[/TD]
[TD]High[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi,

Excel 2013/2016
	A	B	C	D	E	F
1	ID	Total	Location	Severity
2	Case 1	10	East	High		14
3	Case 2	5	South	Medium		9
4	Case 3	8	North	Medium
5	Case 4	4	South	High
6	Case 5	5	South	High
Sheet1

Cell Formulas
Range	Formula
F2	=SUMIFS(B2:B6,C2:C6,"South")
F3	=SUMIFS(B2:B6,C2:C6,"South",D2:D6,"High")

 

[The Grim Discovery]

Thanks FormR - that's grand