| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
I would use a Pivot Table for this.
On Sun, 2 Oct 2005 19:46:01 -0700, tw5633 wrote: How do I get a total sum if I am using 3 columns for references? I am trying to get total sales by salesperson with columns regarding salesperson (Column I), sales status (Column N), and $ Amount (Column L). How do I get the total $ Amount for each salesperson? i.e. I L N Salesman $ Amount Status DP 15000 S PR 10000 P DP 1000 P PR 500 S |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with grouping columns | New Users to Excel | |||
| how to combine several columns into a single column | Excel Discussion (Misc queries) | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| How do I reference non-contiguous columns in another sheet and th. | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
