Filter

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?

Read up on advanced filter, which allows you to filter input that does not contain "July" for example.

Hope it helps

when you setup your filter, select the date column and choose Custom

In the Custom AutoFilter dialog, it'll say Show rows where:DATE
then select - 'is greater than or equal to' and in the next box type your
first date
then select the And radio button and in the second criteria box select -
'is less than or equal to' and type in the other date. Click OK and you
should then see only the date range you require.

"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?
>
>

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

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
>
>