Function Problems

Excel Formula to Check Four Quarter Sheets for Any Data in WPS Office

Muhammad TalhaMuhammad Talha Nov 13, 2026 869 views

Question details

The user needs a spreadsheet formula that checks the same cell across four quarterly worksheets and returns Y when any quarter contains data, or a blank when all four quarter cells are empty.

Excel Formula to Check Four Quarter Sheets for Any Data in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
Working with quarterly worksheets and need a single result cell that shows whether any quarter contains data.
Observed behavior
The formula should return Y when at least one quarter sheet cell C4 is nonblank and return a blank when all four are empty.
Before you start

Open the workbook in WPS Office Spreadsheets and confirm that the four quarterly sheets are named exactly Qtr 1, Qtr 2, Qtr 3, and Qtr 4, or adjust the sheet names in the formula to match your workbook.

Solution 1Recommended

Use an IF Formula with Direct Sheet References to Check All Four Quarter Cells

Best when you need a transparent, Excel-compatible formula that checks each quarterly sheet independently and returns Y if any target cell has data.

This formula adds the results of four logical tests. Each test returns TRUE (1) when the quarter cell is not blank; if the total is greater than zero, at least one quarter contains data.

1
Select the result cell

Click the cell where you want the Y or blank result to appear, for example D4 on a summary sheet.

2
Enter the direct-reference IF formula

Type or paste =IF((('Qtr 1'!C4<>"")+('Qtr 2'!C4<>"")+('Qtr 3'!C4<>"")+('Qtr 4'!C4<>""))>0,"Y","") into the formula bar.

3
Press Enter and verify

Press Enter. The cell shows Y when any Qtr sheet C4 contains data and stays blank when all four Qtr C4 cells are empty.

Use an IF Formula with Direct Sheet References to Check All Four Quarter Cells
Formula result: This formula returns Y when at least one quarterly C4 cell is nonblank and blank when all four are empty.
WPS Spreadsheets solution

Use WPS Office Spreadsheets to Check Four Quarter Sheets with One Formula

Open your quarterly workbook in WPS Office Spreadsheets, enter an Excel-compatible IF formula that references Qtr 1 through Qtr 4, and WPS will return Y or blank automatically based on whether any quarter cell has data.

  1. 1. Open the workbook: Launch WPS Office Spreadsheets and open the workbook that contains the four quarterly sheets.
  2. 2. Select the summary cell: Click the cell where you want to display Y or blank.
  3. 3. Enter the quarter-check formula: Type =IF((('Qtr 1'!C4<>"")+('Qtr 2'!C4<>"")+('Qtr 3'!C4<>"")+('Qtr 4'!C4<>""))>0,"Y","") in the formula bar.
  4. 4. Confirm the result: Press Enter and confirm that the cell returns Y when any quarter contains data, or blank when all four quarter cells are empty.
  5. 5. Save the file: Save the workbook in .xlsx format to preserve compatibility with Microsoft Excel and WPS Office.
One Excel-compatible formula checks four quarterly sheets at onceReturns Y or blank automatically without manual cross-checkingReads, edits, and saves .xlsx files with full Microsoft Excel format compatibilityFamiliar spreadsheet interface makes migration from Microsoft Excel easyFree to use with all core WPS Office applications
microsoft office alternative - wps office

Frequently Asked Questions

Why does the formula use a non-blank comparison instead of ISBLANK?

A non-blank comparison treats cells containing formulas that return empty text as blank, while ISBLANK often returns FALSE for formula-created empty strings. The IF addition method is more reliable when cells contain formulas.

What should I change if my sheet names are different?

Replace Qtr 1, Qtr 2, Qtr 3, and Qtr 4 in the formula with your actual sheet names. If a sheet name contains spaces or special characters, keep it wrapped in single quotes.

Can I modify the formula to count how many quarters have data?

Yes. Use =(('Qtr 1'!C4<>"")+('Qtr 2'!C4<>"")+('Qtr 3'!C4<>"")+('Qtr 4'!C4<>"")) to return the number of quarter sheets in which C4 is nonblank.

Does WPS Office support this Excel formula?

Yes. WPS Office Spreadsheets supports Excel-compatible formulas and can open, edit, and save .xlsx workbooks without converting the formula.

What if the quarterly sheets are not adjacent?

Use the direct-reference IF formula rather than a grouped 3D reference, because a sheet-range reference like 'Qtr 1:Qtr 4' requires the sheets to be in order and adjacent.