=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