Google Sheets COUNTIF status count: check matching records

A Google Sheets COUNTIF status count tells you how many cells match one condition. After this exercise, you can count a chosen status in five practice records, reconcile it with individual record IDs and leave a handover that separates the expected answer from the value you actually checked.

Updated: 19 October 2026.

What does a status count actually establish?

Imagine a freelance studio tracking review items. The coordinator wants to know how many are marked Ready, not the total number of rows and not their monetary value. COUNTIF takes a range and one condition. It answers a narrow question about cell contents. It does not establish that someone really completed the work represented by those contents.

Decide what a row represents before calling the answer an item count. If one project occupies several rows, matching status cells are not necessarily distinct projects. Our fictional input assigns one record to each code. Keep that unit in the result label so a colleague cannot confuse a row count with a customer count.

This is synthetic practice material, not Anar’s implementation or a reported client outcome. No signed-in interface, formula execution, saving, reopening or timing test was performed for this article. The expected answer below is derived from the supplied records. Leave the observed-result field unfinished until you inspect your own spreadsheet.

Build five records you can inspect without a formula

Open sheets.google.com with an existing account you are permitted to use and create a blank practice file. Name it Status count practice. Put Reference in A1 and Status in B1. Use invented codes rather than a customer export. A small input lets you inspect every record instead of trying to diagnose an unfamiliar reporting workbook.

Write down the matching references before entering a calculation: P2 and P4. That establishes an independent expectation of two matching cells in this particular sample. Keeping the references is more useful than keeping the number alone. If something differs later, you can identify which record needs inspection instead of simply declaring the result wrong.

The header is in B1, while the five status cells occupy B2:B6. Keep that boundary explicit. Choosing the entire B column would define a different input, potentially including notes and later records. For this first exercise, use the smallest range that includes every supplied status and nothing else.

If your real source packs several fields into one cell, resolve that layout separately. The split-text exercise deals with field separation. Today, enter the small sample directly. Combining parsing, label cleanup and conditional counting would make a discrepancy harder to explain.

Enter one condition and inspect the actual expression

Put Ready records in D2. In D3, type =COUNTIF(B2:B6,"Ready") and press Enter. The first argument identifies the source cells; the second supplies the text to match. Text conditions belong inside straight double quotation marks. Treat the formula as an instruction you can explain, not an incantation copied from a search result.

Google documents starting a spreadsheet formula with an equals sign. Select D3 again and inspect its formula bar. You should be checking the expression, not merely seeing whether a plausible number appears. Someone could type the expected number directly into that cell without having a working conditional count at all.

The example uses a comma between arguments. If your file reports a syntax error, inspect the function help shown in your spreadsheet and follow the argument separator required there. Record the expression you actually used. Do not keep replacing unrelated settings until a number appears, because that would leave the cause of the problem unexplained.

COUNTIF applies one criterion. Counting Ready items assigned to a particular owner would be a different, multiple-condition request. Google points to COUNTIFS for multiple criteria. Do not present this one-status formula as a complete project report. First make the source boundary, condition and counted unit clear enough for another person to inspect.

An assistant can propose spreadsheet expressions, but that is a separate workflow. The Gemini in Sheets guide explains requesting and reviewing suggestions. No assistant is required for these five records. If you use one for an explanation, still check the referenced cells and matching record IDs yourself.

Reconcile the answer with the matching references

Compare the displayed value in D3 with P2 and P4. The expected count is two, but this article has not observed the value in your account. If the figures differ, inspect the five source cells one by one before changing the expectation. A different answer is a reason to investigate, not permission to redefine the task after seeing the result.

Google states that COUNTIF is not case sensitive. Therefore this exercise does not distinguish Ready from READY as different statuses. Conversely, a different word with a similar business meaning is not automatically the same criterion. Decide how the team uses labels instead of expecting a counting function to interpret every phrase as a person would.

Inspect unexpected spaces and extra characters in any suspicious cell. In this harmless practice file, compare the entry with the supplied sample. In a real working file, do not rewrite the whole column without understanding the source rule. Record which reference changed so a colleague can distinguish an input correction from a formula correction.

A filtered display does not redefine this exercise as a visible-rows-only count. The formula refers to its stated range. Label the result accordingly rather than assuming hidden rows disappear from the calculation. The filter-view workflow produces a saved working view, which is a different deliverable from counting one status across a fixed input.

If you later add a record in B7, do not assume the B2:B6 expression includes it. Decide the new boundary, update the independent matching-reference list and inspect the formula again. A checked result for five records does not certify a growing operational dataset. Every meaningful input change needs a corresponding review.

Leave a small record another coordinator can follow

On Windows, open Start, launch Notepad and create a new document. On Mac, open TextEdit, choose File → New, then Format → Make Plain Text. Record the spreadsheet address, worksheet name, source range, condition and final expression. The recipient should be able to locate the five inputs without asking what the total means. Leave out account passwords and any customer details unrelated to this practice task.

Spreadsheet and worksheet: ___.
Source: B2:B6.
Unit: one coded record.
Criterion: Ready.
Expression: =COUNTIF(B2:B6,"Ready").
Manually matched references: P2, P4.
Expected count: 2.
Actually displayed value: unchecked / ___.
Save and reopen: unchecked / ___.
Unresolved issue and next action: ___.

On Windows, choose File → Save As; on Mac, choose File → Save. Save the note as status-count.txt in Documents, choosing a different name if that file already exists. Close and reopen it. Inspect the expression, source boundary and unfinished observation fields. Saving a note does not validate a spreadsheet, so keep that check separate from the application check you perform next.

Before closing the spreadsheet, inspect its saving status. If it is unclear, leave persistence unconfirmed. Reopen the exact address from your note, inspect D3 and compare the displayed count with the two matching references. Record only what you actually observed. A copied expected answer is not a substitute for inspecting the reopened file.

The named-range exercise covers giving an input boundary a readable name. The formula-protection exercise concerns editing restrictions. Neither is required to explain today’s result. Finish one count before adding labels, permissions or a larger reporting system.

A useful first session ends with one expression, its supporting record IDs and an honest list of remaining checks. Fifteen minutes is a suggested practice timebox, not measured completion evidence. If access or syntax prevents progress, preserve the precise issue and next action. Say what the count establishes: two matching status cells, not two approved clients or verified deliveries.