How to summarize data in Microsoft excel?

Asked By 40 points N/A Posted on -
qa-featured

Hi,

I have an excel spreadsheet including the sales amount of each customer in different months. Please see the image below.

Excel SpreadSheet

This is just for an example. There are thousands of data.

I want to make a summary of total sales for each month. Month in one column and total sales in next column. Can you help me to do this shortly using a function?

SHARE
Best Answer by Geisha Nitta
Best Answer
Best Answer
Answered By 0 points N/A #133767

How to summarize data in Microsoft excel?

qa-featured

In Microsoft Excel there is a function called Pivot table which facilitates to summarize data. Here is the way that you should follow in order to get a summary of data.

I will take the same example that you took.

First select the entire data series without total. Before that, make sure that each data column has a heading.

Then click on the Pivot table option which is in insert tab.

Please see the image below.

Pivot table

Then in the next window click OK.

Pivot Table List

Tick of the Month and sales amount check box.

Then sales of each month will be displayed as total in the pivot table as follows.

PivotTable
Answered By 0 points N/A #133768

How to summarize data in Microsoft excel?

qa-featured

Dear friend I did not know about the excel but I can give you the solution. Friend first a fall you need search in Google and then go to a computer specialist and asked about all think about the excel from the basic and try more and more due to which you didn't have confuse next time.

Thank you.

Login/Register to Answer

Related Questions