View Single Post
  #1   Report Post  
tw5633
 
Posts: n/a
Default how do I sum using 3 reference columns?

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