MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Amateur with a Question


Posted by Will on February 12, 2002 8:50 AM

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


Posted by Mark W. on February 12, 2002 8:53 AM

PivotTable [nt]

Posted by Will on February 12, 2002 9:04 AM

THANKS!