=SUMIF(A:A,"Salesman1",D:D)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jeff" <no_em@ilplease wrote in message ...
I have a long list of orders attributed to four different salespeople. I
want to use a function (in a cell at the bottom of the list) to SUM the
value of all the orders in the list which belong to salesman1, ignoring
all
the others. Then do the same for salesman2 etc...

Salesman's name is in column A, order value is in column D. I KNOW this
is
straightforward, but I just can't figure out how to do it. Help, please!

Thanks