Monthly Summary of Data

[Guest]

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.

 

[Roger Govier]

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