| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
sum of similar products
In Excel 2007, how would I go about getting totals for similar values? For
example, I have 2 coulmns in a sheet. 1 contains the sales reps name and the 2nd contains the sales on a particular invoice. I want to get sales totals by rep. Thanks, Derek |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
sum of similar products
Use a Pivot Table:
http://peltiertech.com/Excel/Pivots/pivotstart.htm In article , dcs68 wrote: In Excel 2007, how would I go about getting totals for similar values? For example, I have 2 coulmns in a sheet. 1 contains the sales reps name and the 2nd contains the sales on a particular invoice. I want to get sales totals by rep. Thanks, Derek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add numbers with corresponding products | Excel Worksheet Functions | |||
| Adding Products | Excel Worksheet Functions | |||
| Combine query to count products with similar names | Excel Worksheet Functions | |||
| Products | Excel Worksheet Functions | |||
| better/faster way than sum products? | Excel Worksheet Functions | |||
Linear Mode
