How i can get sum on basis of Text?

[SHAHZADBABAR]

Building A	5000	Balance
Building B	6000	Clear
Building C	7000	Balance
Building D	8000	Balance
Building C	9000	Expire

<tbody>
</tbody>

is there any way(not VB way) that i will get sum of column"B" on the basis of Column"C"?
like Total Balance = 20,000, Total Clear = 6000 Total Expire = 9000

 

[VoG]

Try like this

Excel Workbook
	A	B	C	D	E	F
1	Building A	5000	Balance		Balance	20000
2	Building B	6000	Clear		Clear	6000
3	Building C	7000	Balance		Expire	9000
4	Building D	8000	Balance
5	Building C	9000	Expire
Sheet1

 

[soefficientas]

How about a pivot table?

 

[SHAHZADBABAR]

Thanks sir, it works greatly.

 

[SHAHZADBABAR]

Yeah Pivot table is also a good idea. I will also try it. thanks for replying.