| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do i create a "look up" to sum values in excel?
Ive got a data sheet listed with product id's, the product, region prod was
sold in, sales channel, and total sales. I need to create a lookup that will allow me to pull up a product and get a break down of sales by region and by sales channel. How can i do this? |
|
#2
|
|||
|
|||
|
Hi
use a pivot table. See: http://www.cpearson.com/excel/pivots.htm http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.ozgrid.com/Excel/excel-pivot-tables.htm -- Regards Frank Kabel Frankfurt, Germany "tbaldwin" schrieb im Newsbeitrag ... Ive got a data sheet listed with product id's, the product, region prod was sold in, sales channel, and total sales. I need to create a lookup that will allow me to pull up a product and get a break down of sales by region and by sales channel. How can i do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Missing values in Excel Line Chart | Charts and Charting in Excel | |||
| Generating Correlated Random Values in Excel | Excel Discussion (Misc queries) | |||
| Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
| How to I create a pdf file from Word or Excel files | Excel Discussion (Misc queries) | |||
Linear Mode
