Microsoft Excel - Calculating Cost by Company - Asked By Kathy Hughes on 20-Mar-14 08:55 AM

If column A contains company names and column B contains $ amounts, how do I summarize the total cost (in column E)for each company in column A.

Thank you, Kathy 

Column A                   Column B        C     Column D                 Column E

Company	Charge		Summary
ABC Company	$   250.00		ABC Company
North Leasing	$   100.00		North Leasing
Trucking A	$    60.00		Trucking A
Sunshine Rentals	$    75.00		Sunshine Rentals
North Leasing	$    25.00			0
Sunshine Rentals	$    700.00
ABC Company	$  1,000.00
ABC Company	$  1,700.00
North Leasing	$   500.00
Sunshine Rentals	$   200.00
Trucking A	$     150.00
Trucking A	$       70.00
	$ 4,830.00

Hi Kathy,

=SUMPRODUCT(($A$2:$A$13=D2)*$B$2:$B$13)

Put this in E2 and copy down.
Regards
Harry

Thank you Harry, much appreciated.  I had an Excel brain freeze today :)

Not a problem Kathy, happens all the time /;-{)}
Just as a matter of interest, your problem is also very easily handled in a Pivot Table which means that Excel does all the work for you.  Also means that as you add data all is taken care of without having to use dynamic ranges. 

Kathy_cocosts.zip

Apologies if I am telling you how to suck eggs.
Regards
Harry