Cómo funciona.
SUMAR.SI.CONJUNTO es una función fundamental de Excel. Suma las celdas de un rango que cumplen con múltiples criterios o condiciones. 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.
Adds up all numbers in a range that meet one or more conditions (e.g., adding sales only for West region and Apple product).
"Think of this like a smart piggy bank. It only adds up coins that match all your criteria (like only summing quarters that are shiny)."
Sintaxis.
Notación Estándar de Excel=SUMAR.SI.CONJUNTO(rango_suma; rango_criterios1; criterios1; [rango_criterios2; criterios2]; ...)Argumentos.
A continuación se detallan todos los parámetros aceptados por esta función.
The range of cells to sum.
Ejemplo:C2:C6The first range evaluated with the criteria.
Ejemplo:A2:A6The condition that must be met in criteria_range1.
Ejemplo:"Fruit"The second range evaluated.
Ejemplo:B2:B6The second condition that must be met.
Ejemplo:">100"Ejemplo práctico.
Caso de Uso Paso a PasoFilter & Sum Regional Sales
Sum the Total Sales of a specific Product in a specific Region.
| Region | Product Name | Sales Amount | Query Region | Result Total |
|---|---|---|---|---|
| West | Apple | 1200 | West | — |
| East | Orange | 950 | Apple | — |
| West | Orange | 800 | — | — |
=SUMIFS(C2:C6, A2:A6, "West", B2:B6, "Apple")Evaluates SUMIFS over the sample table cells, placing the verified output in cell E2.
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.
=SUMAR.SI.CONJUNTO()Comportamiento del resultado.
Returns "Calculated output" based on sample evaluation criteria and active cell references.
Buenas Prácticas
- You can use logical operators (e.g. ">100", "<=50") and wildcards (e.g. "App*", "*east*") inside your criteria.
- Lock all range parameters with `$` so you can drag the formula down without shifting lookup ranges.
Errores Frecuentes
- The sum_range and all criteria_range parameters MUST be identical in shape and dimensions, or SUMIFS will return a #VALUE! error.
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écnicasWhat is the difference between SUMIF and SUMIFS?↓
SUMIF supports only one condition and puts the sum_range last: =SUMIF(range, criteria, [sum_range]). SUMIFS supports up to 127 criteria pairs and places the sum_range first: =SUMIFS(sum_range, criteria_range1, criteria1, ...).
Why does SUMIFS return 0 instead of the expected total?↓
SUMIFS requires ALL conditions to be met simultaneously (AND logic). If no single row satisfies all criteria, it returns 0. Also verify that numeric comparison operators are quoted (e.g., ">100" instead of >100).