Hello, I am trying to make a Profit Sheet for my Online sales

Basically, there are 3 Worksheets (Products / Trans / Reports)

Attatched is the Excel File

  • Products: my Sku and product details with profit for each item
  • Trans: Daily transactions downloaded from online store
  • Reports: This is where all of the Sum data calculated will be sent to



I need "Reports" to take the SKU's listed on Row A, and search "Trans" for any of the Skus that sold, qty, and shipping speed, then add the total amount of the SKU sold, then Multiple that number by the Profit for that SKU which is found on "Products" Sheet, then return the final results to "Reports" in columns B and C (Standard Shipping) (Expedited Shipping)

Sorry if this sounds confusing

PROFIT_REPORT.xlsx