How to get a summary of data in Microsoft excel?

Asked By 20 points N/A Posted on -

I have an excel sheet including sales of each item within a particular period. See the below image.

Sumation of Data

I want to get the total sales of each item during this period. Can someone tell me a way to do this quickly?

Answered By 0 points N/A #145329

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.

Pivot Table in Excel

Now in the next window click OK.

Then a new page will be opened as follows.

Pivot table option

Now click on the “item” field and drag it to “Row labels” area.

Drag and drop options

Drag the “sales” field in to Values area.

Draging and droping functions

Now you can see total sales of each item has been displayed in the new table as follows.

Total sales Figure

Login/Register to Answer

Related Questions