Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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
|
|||
|
|||
=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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I list items in a column with totals? | Excel Discussion (Misc queries) | |||
Indexing items from a pick list | Excel Discussion (Misc queries) | |||
How do I color code items in a drop down list? | Excel Discussion (Misc queries) | |||
Pivot Tables, can I use an external list to select data items? | Excel Worksheet Functions | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |