How to List Today’s Unchecked MSR Numbers with Excel IF Formulas

Excel can return the actual MSR values when two conditions are true: the date in F3:F200 equals today, and the checkbox-linked cells in H3:H200 are FALSE. The result is a single cell that lists only the matching entries from C3:C200.

Trying to understand IF functions

Only rows where the need date in column F matches TODAY() should be included.

The linked checkbox value in column H must still be FALSE, which means the item is not received.

Excel should show the matching MSR numbers from column C under the Orders due today area.

Why COUNTIFS is not enough

COUNTIFS is useful when you only need the number of matches. It cannot return the related text values from another column, so it cannot print the MSR numbers themselves into a result cell.

The formula that returns the MSR numbers

Use the formula below in the output cell where you want the due-today MSR list to appear. It filters the matching rows first, then joins the results into one comma-separated line.

FILTER pulls the rows

It checks C3:C200 and keeps only rows where the date is today and the checkbox-linked value is FALSE.

The asterisk means AND

The expression (F3:F200=TODAY())*(H3:H200=FALSE) requires both conditions to be true for the same row.

TEXTJOIN combines the results

It places all matching MSR numbers into one cell, separated by commas, and ignores empty results.

Use FILTER and TEXTJOIN when Excel must return matching MSR values

For this worksheet, COUNTIFS can count due-today unchecked rows, but it cannot display the related MSR numbers. The working solution is =TEXTJOIN(", ", TRUE, FILTER(C3:C200, (F3:F200=TODAY())*(H3:H200=FALSE), "")), which returns the actual values from column C.

Complete This Workflow with WPS Office

Use Word, Excel, and PPT for FREE

Free Download

WPS Office can run this FILTER and TEXTJOIN workflow directly in WPS Spreadsheets when those functions are available in the installed version.

1. Select the summary cell where the due-today MSR list should appear.
2. Enter =TEXTJOIN(", ",TRUE,FILTER(C3:C200,(F3:F200=TODAY())*(H3:H200=FALSE),"")).
3. Confirm each checkbox is linked to the matching cell in column H and returns a real TRUE or FALSE value.
4. Set one row to today with an unchecked box, then check it. The MSR number should appear and disappear from the result immediately.

If FILTER is unavailable in an older build, use a helper column and filtered list instead of presenting COUNTIFS as a text-return function.

List Today’s Unchecked MSR Numbers with Excel IF Formulas FAQs

Why does COUNTIFS return a number but not the MSR numbers themselves?

COUNTIFS is built to count rows that meet conditions. It does not return related text from another range, so you need FILTER to extract the matching MSR values and TEXTJOIN to combine them.

What should I check if the formula returns nothing?

Confirm that at least one date in F3:F200 is exactly today and that the linked checkbox cell in the same row shows FALSE. Also check that the checkbox is linked to column H rather than only sitting on top of the sheet visually.

How can I verify that the checkbox condition is working correctly?

Click a checkbox and watch its linked cell in column H. It should switch between TRUE and FALSE; if it does not, the formula cannot test the received status correctly.

Why does the formula use an asterisk between the two conditions?

The asterisk multiplies the logical tests so both conditions must be true for a row to pass. In this formula, the row is kept only when the date equals TODAY() and the linked checkbox value equals FALSE.