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?
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.
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.
