How to Sum Up sales data by a product category from anther sheet

M

mel_zhang

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

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

Jason
Wanna be an Excel Exper
 
Top