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

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


--
mel_zhang
------------------------------------------------------------------------
mel_zhang's Profile: http://www.excelforum.com/member.php...o&userid=29825
View this thread: http://www.excelforum.com/showthread...hreadid=495298