Function Problems

Use an Excel FILTER Formula to Bring Day Production Data to a Summary Sheet by Date

Steven ParkerSteven Parker Nov 12, 2026 869 views

Question details

The user needs to return production records from a Day Production worksheet to a Summary worksheet based on a selected date.

Use an Excel FILTER Formula to Bring Day Production Data to a Summary Sheet by 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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the selected date on the Summary sheet

On the Summary worksheet, enter or select the reporting date in cell B1. Format it as a Date using Home > Number Format if needed.

2
Select the first output cell

On the Summary worksheet, click the top-left cell where the returned production table should begin, such as A4.

3
Enter the FILTER formula

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.

4
Adjust the source ranges

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.

Return all matching production rows with the FILTER function
Matching rows are returned automatically: When the date in Summary!B1 changes, the FILTER results update to show records for the newly selected date.
WPS Spreadsheets solution

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. 1. Open the production workbook: Open the .xlsx file in WPS Spreadsheets and select the Summary worksheet tab.
  2. 2. Set the report date: Click the date input cell, such as B1, and enter the production date to summarize.
  3. 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. 4. Insert the FILTER formula: Enter =FILTER('Day Production'!A2:Z100,'Day Production'!A2:A100=Summary!B1,"No records found") and press Enter.
Return every production row that matches the selected reporting date.Use dynamic array results instead of copying formulas down manually.Open and edit Microsoft Excel .xlsx workbooks with compatible spreadsheet formatting.Use a familiar worksheet interface for a smooth move from Microsoft Excel.
QA img-9

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.