Formula Errors

Fix an Excel COUNTIFS Formula for Text in Weekend Cells

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 870 views

Question details

Correct a formula to count text across several separate weekend cell ranges.

Fix an Excel COUNTIFS Formula for Text in Weekend Cells
Product
Microsoft Excel
Device & OS
not provided
Scenario
A worksheet stores weekend entries in four separate two-cell ranges in row 202.
Observed behavior
The combined COUNTIFS formula returns a maximum of two instead of counting text in all weekend cells.
Before you start

Confirm that F202:G202, M202:N202, T202:U202, and AA202:AB202 are the weekend ranges you want to count. Choose whether to count text only or all nonblank cell contents.

Solution 1Recommended

Add Separate COUNTIFS Results to Count Text

Use this formula when you want to count text entries across all four weekend ranges.

COUNTIFS applies multiple range-and-criteria pairs together rather than adding their separate counts. Counting each weekend range separately and summing the results includes all eight cells.

1
Select the result cell

In Excel, click an empty cell outside the four weekend ranges.

2
Enter the formula

Type =SUM(COUNTIFS(F202:G202,"*"),COUNTIFS(M202:N202,"*"),COUNTIFS(T202:U202,"*"),COUNTIFS(AA202:AB202,"*")) in the cell or formula bar.

3
Calculate the count

Press Enter. The result adds the text counts from the four ranges.

Add Separate COUNTIFS Results to Count Text
Check formula separators: If Excel rejects the formula because of your regional settings, replace the argument-separating commas with semicolons.
Count weekend entries in WPS Spreadsheets

Count Text Across Weekend Ranges in WPS Spreadsheets

Use WPS Spreadsheets to enter the same COUNTIFS formula and add text counts from separate weekend ranges.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
  2. 2. Choose a result cell: Click an empty cell outside the weekend ranges.
  3. 3. Enter the formula: In the cell or formula bar, enter =SUM(COUNTIFS(F202:G202,"*"),COUNTIFS(M202:N202,"*"),COUNTIFS(T202:U202,"*"),COUNTIFS(AA202:AB202,"*")).
  4. 4. Calculate the result: Press Enter to display the combined text count.
Count text across multiple nonadjacent weekend ranges.Open and edit Microsoft Excel XLSX and XLS files.Use familiar spreadsheet formulas and a formula bar.
microsoft office alternative - wps office

Frequently Asked Questions

Why does my COUNTIFS formula return no more than two?

COUNTIFS evaluates corresponding cells against all supplied criteria rather than adding counts from each range. With two-cell ranges, it can count at most two matching positions.

Does the wildcard formula count numbers?

No. The "*" criterion matches text, not numeric values. Use COUNTA on the weekend ranges if both text and numbers should count.

Can I count weekend ranges in a different row?

Yes. Replace each row number in the formula with the row you need, keeping the same weekend column pairs or changing them to match your worksheet.

Why does COUNTA count a cell that looks blank?

COUNTA counts a cell containing a formula even when that formula returns an empty string. Select the cell and check the formula bar to see whether it contains a formula.