Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I sum using 3 reference columns?
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 |
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) |