how do I sum using 3 reference columns?

T

tw5633

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
 
J

JMB

=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I sumif using 3 reference columns? 3
How do I sum with 3 reference columns? 2
Multiple Columns in Sum Range using SUMIFS 1
How do I use COUNTIF if I am combining 2 columns? 5
How to ignore a column of numbers in Grand Total for rows 1
Nested formula Value error 4
Sum of values in column A based on 0/1 of column B 2
Sum within a date range meeting one other criteria 3

Top