I am uploading with this message a sample file based on your data.

I defined dynamic ranges to make the formulas reponsive to additions to
new sales. Just add the sales beneath the samples shown in the Sales
sheet and the formulas will find them.

I put three sales summaries on the sales summary sheet. Each sales
summary covers a date range defined in the top left hand corner.
Examine these to see how you would do your own sales summaries, which
you might put on different sheets depending on your desires.

I added a sample pivot table on another sheet, but I am not a big fan
of pivot tables for on-going analysis since they are not automatically
updated with new data; you have to refresh them or have a macro do so.
I also do not like their imposed format, but they can be extremely
useful to people who have difficulty with summarization formulas or who
want a quick one-time analysis.

Hope this helps

Declan O'R


+-------------------------------------------------------------------+
|Filename: SalesData_DOR.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4077 |
+-------------------------------------------------------------------+

--
DOR
------------------------------------------------------------------------
DOR's Profile: http://www.excelforum.com/member.php...o&userid=29088
View this thread: http://www.excelforum.com/showthread...hreadid=488795