We help IT Professionals succeed at work.
Get Started

I need an Excel Formul

wrt1mea
wrt1mea asked
on
278 Views
Last Modified: 2012-05-12
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!
11-2-11.xlsx
Comment
Watch Question
CERTIFIED EXPERT
Most Valuable Expert 2013
Commented:
This problem has been solved!
Unlock 1 Answer and 18 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE