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.

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" <proshail@discussions.microsoft.com> wrote in message
news:C51FE172-7891-468A-A751-E63BEB19CD3C@microsoft.com...
>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.