Needing to track total sales per product...not per sales person or per month

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.

My apologies. I have attached a simple spreadsheet. Glancing at this made up widget spreadsheet might suggest I just need some If's and Then's, but there are many types of widgets, needing to be tracked.

I presumed you were referring to reading the banner and uploading the file when you said to let you know if that works out for me. It did. Otherwise, if you posted something else or uploaded anything I didn't see that. Thank you for your response, though.

You don't say what version you are using. It matters. The solution may be different. You don't say your location. The syntax might be different. However, if I understand correctly, you can use this in B2 and copy down.

=SUMIFS('Products Sold'!B:B,'Products Sold'!A:A,Summary!A2)

if you don't have access to SUMIFS, you can try this:

=SUMIF('Products Sold'!A:A,Summary!A2,'Products Sold'!B:B)