How to count rows where every column is filled in Excel
Formula (Excel and Google Sheets)
=COUNTIFS(B2:B11,"<>",C2:C11,"<>",D2:D11,"<>")Give COUNTIFS a "not blank" condition for each column: =COUNTIFS(B2:B11,"<>",C2:C11,"<>",D2:D11,"<>").
- Result on the example
- 6 in
G1 - Works in
- Every current version
- Google Sheets
- Same formula
See it work
The formula is already in G1. Change any input and the result updates, or edit the formula to experiment.
How it works
"<>" on its own means "not equal to nothing", so it keeps cells that have something in them. With one such condition per column, COUNTIFS counts a row only when every column is filled. Four contacts are missing at least one field, which leaves 6 complete rows.
=COUNTIFS(B2:B11,"<>",C2:C11,"<>",D2:D11,"<>")Result6
B2:B1110 rows × 1 col: "lena@contoso.example", "omar@fabrikam.example", "noor@litware.example", "tom@northwind.example", …A range: 10 cells in one column.
C2:C1110 rows × 1 col: "555-0142", (empty), "555-0187", "555-0119", …A range: 10 cells in one column.
D2:D1110 rows × 1 col: "Contoso", "Fabrikam", "Litware", (empty), …A range: 10 cells in one column.
COUNTIFS(B2:B11,"<>",C2:C11,"<>",D2:D11,"<>")6COUNTIFS: Counts rows that meet every condition.- criteria_range1
B2:B1110 rows × 1 col: "lena@contoso.example", "omar@fabrikam.example", "noor@litware.example", "tom@northwind.example", … - criteria1
"<>" - criteria_range2
C2:C1110 rows × 1 col: "555-0142", (empty), "555-0187", "555-0119", … - criteria2
"<>" - criteria_range3
D2:D1110 rows × 1 col: "Contoso", "Fabrikam", "Litware", (empty), … - criteria3
"<>"
- criteria_range1
In Google Sheets
The same formula works in Google Sheets: =COUNTIFS(B2:B11,"<>",C2:C11,"<>",D2:D11,"<>"). We ran it in Google Sheets mode on the same data and it returns 6.
Other ways to do it
Each one was run on the same example sheet.
| Formula | Result | When to use it |
|---|---|---|
| =SUMPRODUCT((B2:B11<>"")*(C2:C11<>"")*(D2:D11<>"")) | 6 | The same test with SUMPRODUCT, handy when you need to combine it with other array conditions. |
| =ROWS(B2:B11)-COUNTIFS(B2:B11,"<>",C2:C11,"<>",D2:D11,"<>") | 4Different result | Counts incomplete rows: those missing at least one field. Counts the 4 incomplete rows. |
Common mistakes
- A cell with a single space looks empty but passes
"<>". Clean the data with TRIM if forms allow spaces. - For many columns, COUNTIFS gets long. Use a helper column with
=COUNTBLANK(B2:D2)=0and count the TRUEs.
Try it yourself
Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.
Count rows where every column is filled
G1, count the contacts that have an email, a phone and a company filled in.Questions
How do I count rows that are completely empty?
Use "" instead: =COUNTIFS(B2:B11,"",C2:C11,"",D2:D11,"").
How do I find which field is missing most often?
Use COUNTBLANK per column: =COUNTBLANK(B2:B11), and so on.
Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.