# Excel dynamic report

Good afternoon All!

I am trying to create an excel spreadsheet were in one of its tabs it will reflect the sum of items per every item class per customer. I am currently unaware if there is a function that I can use for this.

I am not very sure how to explain it, but look in the table attached. I am looking to add another tab in the spreadsheet that will have the sum of all the items CLASS "X" for a particular customer, so item class will be shown just once per customer.
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Excel & VBA ExpertCommented:
You may use SUMIFS to achieve this. Do it like this.....

On Sheet2
Place the column headers like this.....
A1 = Customer Name
B1 = Item Class
C1 = Total Qty

Now input a customer's name in A2 and an item class in B2, then in C2 try the following formula.....

In C2
=SUMIFS(Sheet1!\$D\$2:\$D\$25,Sheet1!\$A\$2:\$A\$25,A2,Sheet1!\$B\$2:\$B\$25,B2)

The above formula will give you the Total Qty for the customer mentioned in A2 and item class mentioned in B2.

You may change the range reference used in the formula as per your requirement.

Does this help?
0
Commented:
you can also do that using a pivot table.
28696137.xlsx
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Author Commented:
Pivot Table was a better fit on my situation.

Thank you!
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.