How i can get sum on basis of Text?

SHAHZADBABAR

New Member
Joined
Sep 14, 2014
Messages
12
Building A5000Balance
Building B6000Clear
Building C7000Balance
Building D8000Balance
Building C9000Expire

<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
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Try like this

Excel Workbook
ABCDEF
1Building A5000BalanceBalance20000
2Building B6000ClearClear6000
3Building C7000BalanceExpire9000
4Building D8000Balance
5Building C9000Expire
Sheet1
 

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,177
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top