I have a spreadsheet I am trying to total up costs per accounting code per company. The spreadsheet has 3 tabs; 1st Tab is Master and it contains all of the data that has been imported from various invoices. 2nd tab is the name of the company I want to total every accounting code they bill too. 3rd tab is the same with a different company I am totaling.
Keep in mind there will be approximately 100 entries like you see on the Master Sheet. I need each companys tab to list the company name, accounting number, and the total charged to that accounting number. Pay close attention because the accouting codes change.
See attached and good luck!