How to summarize data in Microsoft excel?

Asked By simon john 40 points N/A Posted on - 07/28/2012

Hi,

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

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?

• Status: Open
• Question Views: 1087
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by Geisha Nitta

Go To Solution

Best Answer

Best Answer

Answered By Geisha Nitta 0 points N/A #133767

How to summarize data in Microsoft excel?

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.

Then in the next window click OK.

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.

About Geisha Nitta

Questions
1

Answers
55

Best Answers
27

• Vote Up 0 Vote Down

• Posted on - 07/28/2012
• Question Category: MS Excel

Answered By pinkle07 0 points N/A #133768

How to summarize data in Microsoft excel?

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.

About pinkle07

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/29/2012
• Question Category: MS Excel