COUNTIFS applies criteria to cells across multiple ranges and counts the number of times all criteria are met. SUMIFS adds the cells in a range that meet multiple criteria.
Funciones SI avanzadas
CONTAR.SI.CONJUNTO y SUMAR.SI.CONJUNTO
CONTAR.SI.CONJUNTO y SUMAR.SI.CONJUNTO