Remember Me?

#1
March 1st 05, 04:31 PM
 Jeff Posts: n/a
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

#2
March 1st 05, 04:39 PM
 Bob Phillips Posts: n/a

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

--

HTH

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

"Jeff" <[email protected] 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

#3
March 1st 05, 04:39 PM
 Domenic Posts: n/a

Try...

=SUMIF(A1:A100,"SalespersonName",D1100)

Hope this helps!

In article , "Jeff" <[email protected] 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

#4
March 1st 05, 04:50 PM
 Jeff Posts: n/a

Thanks!

"Bob Phillips" wrote in message
...
=SUMIF(A:A,"Salesman1",D)

--

HTH

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

"Jeff" <[email protected] 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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post andy Excel Discussion (Misc queries) 4 February 22nd 05 09:30 PM Pank Mehta Excel Discussion (Misc queries) 1 February 3rd 05 10:29 AM Beckers1986 Excel Discussion (Misc queries) 1 January 23rd 05 03:02 PM Brian Lofquist Excel Worksheet Functions 0 January 4th 05 07:43 PM Michelle Craig Excel Discussion (Misc queries) 2 December 22nd 04 09:32 PM

All times are GMT +1. The time now is 04:11 AM.