Adding numbers with specific description

[Memar]

Would you please help me to add numbers with certain specific/description. I just wanted to add all numbers which EAST numbers and West numbers separately as the desired result shown below [TABLE="width: 500"]
<tbody>[TR]
[TD]Region [/TD]
[TD]Amount [/TD]
[/TR]
[TR]
[TD]North-West [/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]South-East [/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]South-West [/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]North-East [/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]North-West [/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]South-East [/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]South-West [/TD]
[TD]200[/TD]
[/TR]
[TR]
[TD]TOTAL [/TD]
[TD]1150 [/TD]
[/TR]
[TR]
[TD]EAST[/TD]
[TD]500 - desired result[/TD]
[/TR]
[TR]
[TD]WEST[/TD]
[TD]650 - desired result [/TD]
[/TR]
</tbody>[/TABLE]

Thanks for your time and help.

 

[Eric W]

Try:

	A	B	C
Region	Amount
North-West
South-East
South-West
North-East
North-West
South-East
South-West
TOTAL
EAST
WEST

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]150[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]200[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]100[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]150[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]200[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]150[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]200[/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]1150[/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]500[/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]650[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet8​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]B10 Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TD="align: left"]=SUMIF(A$2:A$8,"*"&A10&"*",B$2:B$8)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Hi,

SUMIF with wildcard match:

Book1
	A	B
1	Region	Amount
2	North-West	150
3	South-East	200
4	South-West	100
5	North-East	150
6	North-West	200
7	South-East	150
8	South-West	200
9	TOTAL	1150
10	EAST	500
11	WEST	650
Sheet520

Cell Formulas
Range	Formula
B10	=SUMIF(A$2:A$8,"*"&A10&"*",B$2:B$8)

Formula copied down.

EDIT: Eric, you were probably half a second quicker than me

 

[Michael M]

Try

Excel 2007
	A	B	C
1	Region	Amount
2	North-West	150
3	South-East	200
4	South-West	100
5	North-East	150
6	North-West	200
7	South-East	150
8	South-West	200
9	TOTAL	1150
10	EAST	500
11	WEST	650
12
Sheet1

Cell Formulas
Range	Formula
B10	=SUMIF(A2:A8,"*East",B2:B8)
B11	=SUMIF(A2:A8,"*West",B2:B8)