Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Sum Up sales data by a product category from another sheet | Excel Worksheet Functions | |||
Impoting data from Sheet 1 to Sheet 2 | Excel Discussion (Misc queries) | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
pull data from sheet two, then fill in the data to sheet one (part | Excel Worksheet Functions |