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.
Bookmarks