Thread: summing up same words

Is there a way to sum up the column A that are the same but using column B's value? Example:

car 3
car 4
cat 1
dog 1
car 6
dog 3

I wanted to sum up all of "car". In this case it's 13. I wanted it to be as simple as possible. Maybe just using formulas and not macros. However if macros is needed I can use that too as long as the output area is simple to copy and paste or use.

A Sumif function might do what you want. See the attached.

great thanks! however, is there a way of displaying:

car
cat
dog

on the results area without having to actually type the names in on the first column?
basically i wanted to have excel also put in those 3 different items on the first column as well. Currently, I may have say 20,000 rows and say 5000 of those rows are unique different names so I wanted to have excel tell me those 5000 unique names and also count it for me without me having to actually type in each uniqe names myself and then counting it using that reference. So basically what I wanted was to just copy and paste into a sheet all the info, then get a result of all the names combined (one unique name per row) and have their quantity show up

Make a unique list of values and reference that in your formula in the criteria section.

Originally Posted by zbor

You can use a Pivot table.

Only you need to define Title row...

I don't have excel 2007, only 2003

Can you do this again on 2003? That would be greatly appreciated!

Did you create the pivot table using the original info on top or on the bottom data?

try this my friend.