New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Excel: SUMAR.SI, CONTAR.SI y PROMEDIO.SI

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Excel: SUMAR.SI, CONTAR.SI y PROMEDIO.SI

Quiz

(13)
Played 80 %Accuracy 57 Average time 03:37
Create copy

About this activity

Funciones de criterios

Created by

Edwin Carrillo Castro
Edwin Carrillo Castro
Colombia

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Excel: SUMAR.SI, CONTAR.SI y PROMEDIO.SI
 

Excel: SUMAR.SI, CONTAR.SI y PROMEDIO.SIOnline version

Funciones de criterios

by Edwin Carrillo Castro
1

¿Qué devuelve SUMAR.SI(rango_criterios, criterio, rango_suma) en Excel?

2

¿Qué equivale CONTAR.SI(rango, criterio) en Excel?

3

¿Qué hace PROMEDIO.SI(rango_criterio, criterio, rango_promedio)?

4

Si quiero sumar ventas solo de 2024 en un rango, ¿qué argumento usaría en SUMAR.SI?

5

Para contar productos con stock mayor a 50, ¿qué función y criterio usarías con CONTAR.SI?

6

¿Qué rango se usa como rango_suma en SUMAR.SI si solo quieres sumar precios de artículos de tipo A?

7

Si en CONTAR.SI usas criterio "<>0", ¿qué se cuenta?

8

¿Qué diferencia hay entre SUMAR.SI y SUMAR.SI.CONJUNTO?

9

¿Qué devuelve PROMEDIO.SI(rango_criterio, criterio, rango_promedio) si ningún elemento cumple el criterio?

10

¿Qué versión de Excel soporta PROMEDIO.SI.CONJUNTO y otros criterios múltiples?

Explicación

SUMAR.SI suma solo los valores cuyo criterio se cumple en el rango especificado.

CONTAR.SI cuenta celdas que cumplen el criterio; no suma ni promedia.

PROMEDIO.SI usa rango_criterio para aplicar el criterio y promedia el rango_peso.

El criterio debe comparar años, por ejemplo F:E con 2024.

Usa un operador lógico con el criterio entre comillas.

rango_suma debe contener los valores que se van a sumar.

<>0 significa diferente de cero.

SUMAR.SI.CONJUNTO permite múltiples criterios.

Si no hay coincidencias, devuelve error de promedio.

PROMEDIO.SI y CONCATENOS modernos están en versiones actuales; PROMEDIO.SI.CONJUNTO es más reciente.

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.