Archive of Mr Excel Message Board

I have downloaded a spread sheet from my Pay-For-Performance search engine (Overture.com). The spread sheet includes all of my search terms (in one column)and the costs I paid for each search term (in another column) from January 1 to January 31. The problem is that the spreadsheet displays each search term and cost PER DAY. How do I combine all similar search terms (with their associated costs) so that I can get a total cost per search term from January 1 to January 31?

Thanks