A B C D E F
1 T B 0.00
2 H 400.00
3 C V 1,000.00
4 C B 1,000.00
5 C B 1,000.00
6 C E 1,000.00
7 E 300.00
8 T H V 50.00
9 C H 1,000.00
10 C E 1,000.00
11 T V 20.00
12 C B 1,000.00
13 C B 1,000.00
14 E 500.00
5 3 4 3


Totals C T Deposits
Business 5
Home 3
Education 4
Vehicle 3

column A has the status of C for Completed or T for Terminated. Column B to
E are the initials for Business, Home, Education and Vehicle, and the last
column is the deposit amount for each. I would like to know how many in my
column B for business that completed and terminated, and also the total of
deposits made for business. The same with the Home, Education and Vehicles.

Any help, please.