How do I sum with 3 reference columns?
 

I want to show the total sales dollars for a salesperson. Basically saying
IF column I=DP and Column N=S,=Sales by sales person. Any suggestions would
be appreciated.


Column I Column L Column N
Salesman $ Amount Status
DP 14000 S
DP 20000 NI

=SUMPRODUCT(--($I$2:$I$40="DP"),--($N$2:$N$40="S"),$L$2:$L$40)

tw5633 wrote:
I want to show the total sales dollars for a salesperson. Basically saying
IF column I=DP and Column N=S,=Sales by sales person. Any suggestions would
be appreciated.


Column I Column L Column N
Salesman $ Amount Status
DP 14000 S
DP 20000 NI

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

Hi,

You may try this out (Ctrl+Shift+Enter):

=sum(if((range1="DP")*(range2="S"),sumrange))

Regards,

Ashish

"tw5633" wrote:

I want to show the total sales dollars for a salesperson. Basically saying
IF column I=DP and Column N=S,=Sales by sales person. Any suggestions would
be appreciated.


Column I Column L Column N
Salesman $ Amount Status
DP 14000 S
DP 20000 NI