sum particular items from a list

J

Jeff

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
 
B

Bob Phillips

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

--

HTH

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

Domenic

Try...

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

Adjust the range accordingly.

Hope this helps!
 
Top