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&G, 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&G
GLOBAL
A&R
A&G
so A&G 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.
2007-12-27
15:05:17
·
5 answers
·
asked by
Anonymous