Fix an Excel COUNTIFS Formula for Text in Weekend Cells
Question details
Correct a formula to count text across several separate weekend cell ranges.

- 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.
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.
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.
In Excel, click an empty cell outside the four weekend ranges.
Type =SUM(COUNTIFS(F202:G202,"*"),COUNTIFS(M202:N202,"*"),COUNTIFS(T202:U202,"*"),COUNTIFS(AA202:AB202,"*")) in the cell or formula bar.
Press Enter. The result adds the text counts from the four ranges.

Use COUNTA to Count All Nonblank Weekend Cells
Use COUNTA if numbers, text, and other nonblank values should all be included.
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. Open the workbook: Open WPS Spreadsheets and use Open to select your workbook.
- 2. Choose a result cell: Click an empty cell outside the weekend ranges.
- 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. Calculate the result: Press Enter to display the combined text count.

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.




