Cómo funciona.
CONTAR es una función fundamental de Excel. Cuenta el número de celdas de un rango que contienen valores numéricos. Permite automatizar hojas de cálculo, simplificar fórmulas complejas y analizar datos con total precisión en Microsoft Excel y Google Sheets.
💡 En palabras sencillas.
Counts how many cells in a range contain actual numbers, completely ignoring text or blank cells.
"Think of this like counting coins in a jar. It ignores any buttons, paper clips, or receipts, counting only the coins (numbers)."
Sintaxis.
Notación Estándar de Excel=CONTAR(valor1; [valor2]; ...)Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The first cell reference, range, or value to count.
Ejemplo:B2:B6Additional items or ranges to count.
Ejemplo práctico.
Caso de Uso Paso a PasoCount Numeric Entries
Count how many days have numeric attendance logged, ignoring "Absent" text entries.
| Day | Attendance Count | Status | Days Logged | |
|---|---|---|---|---|
| Monday | 24 | Done | — | — |
| Tuesday | Absent | Done | — | — |
| Wednesday | 26 | Done | — | — |
=COUNT(B2:B6)Evaluates COUNT over the sample table cells, placing the verified output in cell D2.
Generador de fórmula.
Abrir Asistente CompletoPersonaliza los campos de argumento a continuación para generar una fórmula lista para copiar y pegar en tu hoja de cálculo.
=CONTAR()Comportamiento del resultado.
Returns number 5 based on sample evaluation criteria and active cell references.
Buenas Prácticas
- To count all non-empty cells (including text and numbers), use the COUNTA function instead.
- To count cells based on specific conditions, use COUNTIF or COUNTIFS.
Errores Frecuentes
- If you have numbers formatted as text, COUNT will ignore them. Make sure your values are formatted as numbers.
Compatibilidad de plataforma y versiones.
Matriz verificada con base en los motores de cálculo oficiales de Microsoft Excel y Google Sheets.
Core standard function supported across all modern and legacy Microsoft Excel versions (365, 2021, 2019, 2016, 2013, 2010), as well as Excel for the Web and Mac.
100% compatible with Google Sheets. Uses identical argument order, data types, and standard calculation logic.
Preguntas frecuentes.
Dudas TécnicasCan I use COUNT across different worksheets in Excel?↓
Yes. You can reference cells located on other sheets by including the sheet name followed by an exclamation mark, for example: =COUNT(Sheet2!A2:A10). If the sheet name contains spaces, enclose it in single quotes: ='Q1 Report'!A2:A10.
What is the most common reason for errors in COUNT?↓
If you have numbers formatted as text, COUNT will ignore them. Make sure your values are formatted as numbers.
Does COUNT work identically in Google Sheets?↓
Yes, COUNT is supported in both Microsoft Excel and Google Sheets with standard evaluation behavior.