<div>
You may use SUMIFS to achieve this. Do it like this.....<br />
<br />
On Sheet2<br />
Place the column headers like this.....<br />
A1 = Customer Name<br />
B1 = Item Class<br />
C1 = Total Qty<br />
<br />
Now input a customer's name in A2 and an item class in B2, then in C2 try the following formula.....<br />
<br />
In C2<br />
<b>=SUMIFS(Sheet1!$D$2:$D$25,<wbr />Sheet1!$A$<wbr />2:$A$25,A2<wbr />,Sheet1!$B<wbr />$2:$B$25,B<wbr />2)</b><br />
<br />
The above formula will give you the Total Qty for the customer mentioned in A2 and item class mentioned in B2.<br />
<br />
You may change the range reference used in the formula as per your requirement.<br />
<br />
Does this help?
</div>


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?

28696137.xlsx

<div>
Pivot Table was a better fit on my situation.<br />
<br />
Thank you!
</div>


Pivot Table was a better fit on my situation.

Thank you!

<div>
<div class="content wysiwyg-content">
Good afternoon All!<br />
<br />
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.<br />
<br />
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 &quot;X&quot; for a particular customer, so item class will be shown just once per customer.<a href="https://filedb.experts-exchange.com/incoming/2015/07_w28/922735/Capture1.PNG" target="_blank" title="Excel table (17 KB)"><img alt="Excel table" class="file-block lazyload" style="max-width: 345px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w28/922735/Capture1.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2015/07_w28/922735/Capture1.PNG" target="_blank" title="Excel table (17 KB)"><img alt="Excel table" class="file-block lazyload" style="max-width: 345px;" data-src="https://filedb.experts-exchange.com/incoming/2015/07_w28/922735/Capture1.PNG" /></a>
</div>
</div>


Capture1.PNG

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.

Excel dynamic report

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.