Filter

[Guest]

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?

 

[Morrigan]

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

Hope it helps

 

[Guest]

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

In the Custom AutoFilter dialog, it'll say Show rows whereATE
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.

 

[Debra Dalgleish]

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.

 

[Guest]

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