See replies to your previos posts.

Biff

"tw5633" wrote in message
...
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