Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Monthly Summary of Data
I am having Daily Sales Figures for the entire year being (Invoice No.,
Date, Name of Seller, Net Sales Amount, Tax, Gross Sales Amount). Now if i want a Monthly summary from the entire data of say ( Net Sales, Tax, Gross Sales) how do i get it in excel. |
#2
|
|||
|
|||
Hi
I would use a Pivot Table to summarise the data. Take a look at Debra Dalgliesh's site for some guidance on how to sue Pivot Tables http://www.contextures.com/tiptech.html -- Regards Roger Govier "proshail" wrote in message ... I am having Daily Sales Figures for the entire year being (Invoice No., Date, Name of Seller, Net Sales Amount, Tax, Gross Sales Amount). Now if i want a Monthly summary from the entire data of say ( Net Sales, Tax, Gross Sales) how do i get it in excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude data from summary totals when hidden | Excel Worksheet Functions | |||
Exclude hidden data from summary totals | Excel Discussion (Misc queries) | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) | |||
Creating a summary from existing spreadsheet data ... | Excel Worksheet Functions |