I would use a Pivot Table for this.

On Sun, 2 Oct 2005 19:46:01 -0700, 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