Please help. I have spent the past 18 hrs trying to figure this out....and I know it's not that hard. I simply want to be able to have an overview worksheet (or a summary) worksheet that shows me the total sales per product. I do not need to track how many red Widgets Johnny sold or how many more blue Widgets Jane sold during the month of Nevervember. I just want to be able to quickly see that my summary page with ALL of my products listed (I don't want to use a filter that lets me easily change from Red Widgets to Blue Widgets and look at my totals. I want 2 worksheets. 1 that I already have where I add a new row each time a different widget is sold. I want a 2nd "summary" worksheet that shows all running totals (ie Red Widgets Sold: $5,000.00 | Blue Widgets Sold: $6,000.00 | Green Widgets Sold: $700.00. I've been playing with VLOOKUP, LOOKUP, and SUMIF. I thought I had finally found what I could tweak and make work. It was perfect. Simple and easy ('=SUM(LOOKUP($C$2:$C$10,'Lookup Table'!$A$2:$A$16,'Lookup Table'!$B$2:$B$16)*$D$2:$D$10*($B$2:$B$10=$G$1))..... however, Lookup #1 looks up the master list of goods and returns the corresponding price for each good (my widgets don't have set prices, I don't need this), Lookup #2 determines the qty purchased of each product and then multiplies that by the previously referenced unit price. Each row record is 1 sale. No need for qty sold. Then in the end....based on which employee made the sales, the price per unit, and qty of unit...you finally arrive at the total revenue generated by employee x. I cannot figure out how to cut out all this extra fluff....and just simply have my summary page keep a total sum value for Blue Widgets sold, and a separate value for the Reds, Purples, etc. Please help. I want that every time "Blue Widget" appears in column A, dollar amount shown in column B is added to the running total (FOR BLUE WIDGETS; NOT FOR ALL WIDGETS. Thanks in advance. I know this is child's play simple for the majority of everyone on here except me apparently.