Intro: I am attempting to sum together some invoices in a rather large spreadsheet. Each row is a specific invoice for a particular company. I would like to sum the invoices for each company.
But here's the tricky bit.
Invoices/bills are submitted by different people. So John Smith might invoice Company ID: 1001 $50, then Sallie Mae might invoice Company ID: 1001 $200.
Ideally, I would like a table showing the total invoices from every person for each company, and then a column for the total amount billed for each company.
Question: What functions should I look at to accomplish this? I'm assuming that, due to the dynamic nature of the length of this particular document from month to month, I won't be able to do this straight in Excel. Is this something that I can do in Visual Basic?
Some Help: Check out this Google Doc to see some sample data, and the ideal output. https://docs.google.com/spreadsheet/ccc?key=0At5iFHDfTNkkdG8tUzRhaEQ1dFRqN0tWOEp0VmFpY0E&usp=sharing