sum particular items from a list
 

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

=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

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

Thanks!

"Bob Phillips" wrote in message
...
=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