Hi,
I have two worksheets, first one with "name", "product category", and "product", second one with "product" (sames as the first sheet product), "sales", "cost". A salesperson charge certain unique product categories and each of them contain unique products.

How can I sum up the "sales" and "cost" by the "product category" with the
least effort. (VB is not allowed

Jason
Wanna be an Excel Expert