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