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 |
#2
|
|||
|
|||
See replies to your previos posts.
Biff "tw5633" wrote in message ... 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 |
#3
|
|||
|
|||
=SUMPRODUCT(--($I$2:$I$5="DP"),--($N2:N$5="S"), $L$2:$L$5)
adjust the ranges as necessary. also "DP" and "S" can be replaced with cell references that contain the name and status for which you are looking. "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 |
#4
|
|||
|
|||
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) |