How can I combine data from a list?

[Guest]

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?

 

[Guest]

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.

 

[Dave Peterson]

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