Use an Excel FILTER Formula to Bring Day Production Data to a Summary Sheet by Date
Question details
The user needs to return production records from a Day Production worksheet to a Summary worksheet based on a selected date.

- Product
- Microsoft Excel workbook with Day Production and Summary worksheets
- Device & OS
- not provided
- Scenario
- A date is selected on the Summary sheet, and all production rows for that date need to appear in the summary area.
- Observed behavior
- The required formula depends on the source data range, the date column, and the fields that must be returned.
Confirm that the selected date on the Summary sheet and the dates in the Day Production sheet are real spreadsheet dates, not text. Leave enough empty cells below and beside the formula location for the returned rows to spill into.
Return all matching production rows with the FILTER function
Use this method when you have Microsoft 365, Excel for the web, or a spreadsheet version that supports dynamic-array formulas and you need every row for the selected date.
This formula checks the date column in Day Production and returns every matching row from the selected source range. Change the ranges to match your workbook, and replace Summary!B1 if your selected date is in another cell.
On the Summary worksheet, enter or select the reporting date in cell B1. Format it as a Date using Home > Number Format if needed.
On the Summary worksheet, click the top-left cell where the returned production table should begin, such as A4.
Type =FILTER('Day Production'!A2:Z100,'Day Production'!A2:A100=Summary!B1,"No records found") and press Enter. This assumes column A contains production dates and columns A:Z contain the data to return.
Replace 'Day Production'!A2:Z100 with the columns you want displayed, and replace 'Day Production'!A2:A100 with the corresponding date-column range. Both ranges must start and end on the same data rows.

Match dates that include production times
Use this variation when the Day Production date column contains dates with time values, such as 4/15/2024 7:30 AM, and an exact date match returns no records.
Filter Day Production Records into a WPS Spreadsheets Summary by Date
WPS Spreadsheets can create a date-driven production summary with a dynamic FILTER formula. Enter the report date on the Summary sheet, point FILTER to the Day Production data, and let matching rows update when the selected date changes.
- 1. Open the production workbook: Open the .xlsx file in WPS Spreadsheets and select the Summary worksheet tab.
- 2. Set the report date: Click the date input cell, such as B1, and enter the production date to summarize.
- 3. Select an empty results cell: Click the top-left cell for the returned records, such as A4, making sure the spill area is empty.
- 4. Insert the FILTER formula: Enter =FILTER('Day Production'!A2:Z100,'Day Production'!A2:A100=Summary!B1,"No records found") and press Enter.

Frequently Asked Questions
How do I return only selected columns from the Day Production sheet?
Change the first FILTER range to only the columns you need. For example, use 'Day Production'!A2:D100 to return columns A through D, while keeping the date-condition range pointed to the date column.
Why does FILTER show “No records found” when the date looks correct?
The source values may include times or may be stored as text. If times are included, use INT('Day Production'!A2:A100)=INT(Summary!B1). If values are text, convert them to real dates before filtering.
Can I use a cell other than Summary!B1 for the selected date?
Yes. Replace Summary!B1 in the formula with the actual date cell, such as Summary!D2. Keep the worksheet name in single quotation marks if it contains spaces.
What happens when there are multiple production records for the same date?
FILTER returns all matching rows automatically. The results spill into adjacent cells, so do not place values or formulas in the output area.
Can this formula return data from another workbook?
FILTER can reference another workbook while the source workbook is available, but using data in the same workbook is more reliable for a production summary. Open the source workbook if external references do not refresh.




