Thanks all........great help and much appreciated

"Debra Dalgleish" wrote:

If you filter the data, you can use the Subtotal function in your
summary report, to sum only the filtered data. For example, if your
amounts are in column E, use this formula in the summary:

=SUBTOTAL(9,E:E)

Look in Excel's Help for the different arguments you can use in the
Subtotal function.

renold1958 wrote:
Have a spreadsheet, with column A: Date Column B: Daily Takings Column C:
Profit and Column D: %

All data is recorded on a daily basis for every day of the financial year.

A summery report for data is made on the same sheet for the total of the
financial year, which is easy enough to do for the entire year. How do I
filter so that only data appears in the summery report from lets say July 1 -
July 21....or any other dates I choose..........ie: is it somehow possible to
enter Begiining Date in a cell and End dat in another cell, so it filters the
Date column and only have that dat appear in the summery report?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html