Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How can I combine data from a list?
For example: suppose I had a very simple list, with two columns: "Name" and
"Number". The category "name" has three items: Dog, Cat, and Dog. Each of those three items has a corresponding "number" value: 3, 4, and 5. I'm trying to find a function that would recognize the fact that I have "Dog" listed twice, and would sum the 3 & 5 values listed next to each "Dog", leaving me with a two-item list: Dog, 8 & Cat, 4. Is there a way to do this? |
#2
|
|||
|
|||
A Pivot Table will do that nicely for you:
Set the Name as a ROW and the Number as the DATA. See if that works for you. Post back if you need more help. -- Regards, Ron |
#3
|
|||
|
|||
It sounds like you want to use =sumif().
You can read about it in Excel's help or visit Debra Dalgleish's site: http://www.contextures.com/xlFunctions01.html#SumIf adamdm8676 wrote: For example: suppose I had a very simple list, with two columns: "Name" and "Number". The category "name" has three items: Dog, Cat, and Dog. Each of those three items has a corresponding "number" value: 3, 4, and 5. I'm trying to find a function that would recognize the fact that I have "Dog" listed twice, and would sum the 3 & 5 values listed next to each "Dog", leaving me with a two-item list: Dog, 8 & Cat, 4. Is there a way to do this? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Extracting/look up data from a list and select multiple instances | Excel Worksheet Functions | |||
HELP: Data > Validation ---List ----Formula | Excel Worksheet Functions | |||
validate data from list without picklist | Excel Discussion (Misc queries) |