Sum Up for a particular client - Excel Function

[30percent]

Hi,

I'm working on a table. On column A I have "last name of clients" e.g. smith, jones, lopez. On column B I have "clients' expenditures in $ term".

Can someone please show me the excel function that I can use, to sum all the expenditures($) for a particular client e.g. lopez on cell C1?

Thank you!

 

[hiker95]

30percent,

Excel Workbook
	A	B	C
1	last name of clients	clients' expenditures	400
2	smith	100
3	jones	200
4	lopez	300
5	smith	100
6	jones	200
7	lopez	100
8
Sheet1

 

[shadow12345]

sounds like you want a pivot table to me.

here is a guide for these.

http://spreadsheets.about.com/od/datamanagementinexcel/tp/090929-excel-pivot-table-tutorial-hub.htm

 

[30percent]

thank you!!!