How do I sum with 3 reference columns?

[tw5633]

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

 

[Aladin Akyurek]

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

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.

 

[Ashish Mathur]

Hi,

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

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

Regards,

Ashish