how do I sumif using 3 reference columns?

T

tw5633

I want to show sales by salesperson. By using the worksheet format below I
want to sum column L if column I = salesperson and column N = Sales status of
sold.

ColumnI ColumnL ColumnN
Salesman $ Amount Status
DP 14000 S
DP 20000 P
PR 1000 L

Any help would be very appreciated.
 
T

tw5633

I was searching for the Q & A and couldn't locate it, so I reposted 2 more.
Sorry. However, thank you very much for the support.
 
Top