Try...

=SUMIF(A1:A100,"SalespersonName",D1:D100)

Adjust the range accordingly.

Hope this helps!

In article , "Jeff" <no_em@ilplease wrote:

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