Totaling Cell to the right of like labels

lovit · Mar 13th, 2002, 06:36 PM

I have a ledger where the labels in Column B change each month. There are repeat values in column B: which I would like to subtotal or SUM.

A B C
2/13 City Bank 5.00
2/15 ABC pest 100.00
2/15 contract help 50.00
2/25 City Bank 50.00
2/30 contract help 150.00
3/1 ABC pest 100.00
3/1 Gloria Indoors 200.00

The result I want is

City Bank 55.00
ABC Pest 200.00
Contract help 200.00
Gloria Indoors 200.00

Each month the labels might be different so I don't want to have to put in the formula what label to search for.

[ This Message was edited by: lovit on 2002-03-13 18:13 ]

NateO · Mar 13th, 2002, 08:16 PM

See the menu items "Data"-> "subtotals"

Subtotal by change in value in column B.

Cheers,

Nate

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 06:36 PM	#1
lovit New Member Join Date: Mar 2002 Posts: 1	I have a ledger where the labels in Column B change each month. There are repeat values in column B: which I would like to subtotal or SUM. A B C 2/13 City Bank 5.00 2/15 ABC pest 100.00 2/15 contract help 50.00 2/25 City Bank 50.00 2/30 contract help 150.00 3/1 ABC pest 100.00 3/1 Gloria Indoors 200.00 The result I want is City Bank 55.00 ABC Pest 200.00 Contract help 200.00 Gloria Indoors 200.00 Each month the labels might be different so I don't want to have to put in the formula what label to search for. [ This Message was edited by: lovit on 2002-03-13 18:13 ]

Mar 13th, 2002, 08:16 PM	#2
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	See the menu items "Data"-> "subtotals" Subtotal by change in value in column B. Cheers, Nate