| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| 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 | |||
Threaded Mode
