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

Region	Amount
North-West	150
South-East	200
South-West	100
North-East	150
North-West	200
South-East	150
South-West	200
TOTAL	1150
EAST	500 - desired result
WEST	650 - desired result

<tbody>
</tbody>

Thanks for your time and help.

 

[Eric W]

Try:

	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

<tbody>
</tbody>

Sheet8​

Worksheet Formulas B10 Cell Formula =SUMIF(A$2:A$8,"*"&A10&"*",B$2:B$8) <tbody> </tbody>

<tbody>
</tbody>

 

[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)