COUNTIF in Excel & Google Sheets
Counts how many cells in a range meet a condition. Works with text, numbers, dates and wildcards.
Syntax
=COUNTIF(range, criteria) Example: Count finished tasks
=COUNTIF(B2:B6, "Done") =CONTAR.SI(B2:B6; "Done") Counts the cells in column B that say "Done".
COUNTIF in Spanish
In Spanish Excel and Google Sheets, COUNTIF is called CONTAR.SI. It's the same function: files translate automatically when opened in another language. When you type it by hand, the name and the argument separator change.
| English | Spanish | |
|---|---|---|
| Function | COUNTIF | CONTAR.SI |
| Separator | , | ; |
| Example | =COUNTIF(B2:B6, "Done") | =CONTAR.SI(B2:B6; "Done") |
The separator depends on regional settings: Spanish versions usually use semicolons, but countries with a decimal point (like Mexico) may use commas.
Translate another formulaArguments
COUNTIF FAQ
What is COUNTIF in Spanish?
In Spanish, COUNTIF is CONTAR.SI. When you type it by hand in a Spanish Excel, arguments are usually separated by semicolons (;): =CONTAR.SI(B2:B6; "Done")
Does COUNTIF work in Google Sheets?
Yes. COUNTIF works in Google Sheets with the same syntax as in Excel. In a sheet set to Spanish it's called CONTAR.SI. The separator (comma or semicolon) follows the sheet's locale, under File → Settings.
How do I count cells that contain some text with COUNTIF?
Use wildcards: =COUNTIF(A2:A100, "*north*") counts cells that contain "north" anywhere. The asterisk stands for any number of characters.
How do I use COUNTIF with two conditions?
Use COUNTIFS, which takes several range/condition pairs: =COUNTIFS(B2:B100, "Done", C2:C100, "North").