N/APosted on - 08/21/2012
I have an excel sheet including sales of each item within a particular period. See the below image.
I want to get the total sales of each item during this period. Can someone tell me a way to do this quickly?
How to get a summary of data in Microsoft excel?
I will explain an easy way to get a summary of sales of each item. In this scenario we can use “pivot table” option in Microsoft Excel.
I will take same example. First select the entire table with headings. And click on the insert tab. Then click on the pivot table icon.
Now in the next window click OK.
Then a new page will be opened as follows.
Now click on the “item” field and drag it to “Row labels” area.
Drag the “sales” field in to Values area.
Now you can see total sales of each item has been displayed in the new table as follows.