Thread: How to Sum Up sales data by a product category from another sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jason_Shanghai
 
Posts: n/a
Default How to Sum Up sales data by a product category from another 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".

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
Reply With QuoteReply With Quote