Pivot formula-list of song titles

I'm sorry for the topic description, but I don't know what this particular formula would be called

I have a list of song titles & list of amounts, with the song titles having multiple entries. What I need is a formula that would give me a total amount for each song title. In other words, there are 3 entries for the song "1755", with the following amounts: 2.01, -.60, & .89. I need a formula that would give me the total (2.30) automatically (either in the next column or replacing the other amounts). I tried doing a search, but can't come up with anything. Here is a link to an example of the spreadsheet.

http://spreadsheets.google.com/pub?k...8jpmo8z_IF8LVg

Thanks!
Paula

Hi, Paula. How about a title something like "Summarizing Data"?

It sounds like a pivot table might be what you are after. Here is a good site to read up on how to create on from your data:

http://www.cpearson.com/excel/pivots.htm

HTH

Jason

Thank you SO much! That is exactly what I needed!!