Microsoft excel, i need hellp?

hi, i am working for a trucking company, we have a spreadsheet on microsoft excel.

we have like e.g. 200 companies that we deal with. On the spread sheet that we have, A company like A%26G, for example, might be on the spreadsheet like 6 times because thats how many times we have worked with them. so even though we have worked with like 200 companies, on my spreadsheet i have like 4 or 5 hundred because we might of worked with a company more than once. And the list might look like this

A%26G

GLOBAL

A%26R

A%26G

so A%26G is there more than once but scattered throughout the sheet.

Now my question is, i am working on a new sheet.

on my new sheet, i want to have each companys name and the total amount of money for that company this year. So instead of clicking CTRL F and going one by one adding up the total profit and then pasting it onto my new spreadsheet, IS THERE AN EASIER WAY to get the total of each company without going one by one.

Microsoft excel, i need hellp?virus scan

If all of the company names are in one column, you can try sorting alphabetically by that column, that way they are all together. That should make it a little easier to find them all. If the company names are in different columns, the find (CTRL F) is probably going to be your best bet.

Microsoft excel, i need hellp?anti virus scan