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
Froggy Jumps
Froggy Jumps

Función SUMAR.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

Función SUMAR.SI

Froggy Jumps

Played 5 %Accuracy 40 Average time 01:40
Create copy

About this activity

La función SUMAR.SI es una de las herramientas más útiles de Excel para realizar cálculos condicionales.
Permite sumar valores en un rango que cumplen con un criterio específico.

Created by

Cristina Córdova
Cristina Córdova
Peru

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
Función SUMAR.SI
 

Froggy Jumps

Función SUMAR.SIOnline version

La función SUMAR.SI es una de las herramientas más útiles de Excel para realizar cálculos condicionales. Permite sumar valores en un rango que cumplen con un criterio específico.

by Cristina Córdova
1

¿Cuál es el orden correcto de los argumentos en la función SUMAR.SI?

2

Si el argumento [rango_suma] se omite en la función, ¿qué celdas sumará Excel?

3

Para sumar valores mayores a 100, ¿cómo debe escribirse el criterio correctamente?

4

Tienes una lista de productos en A2:A10 y sus precios en B2:B10. ¿Qué fórmula suma el precio de los productos llamados "Monitor"?

5

¿Qué sucede si el rango y el rango_suma tienen tamaños diferentes (ej. A1:A10 y B1:B5)?

6

Para sumar valores que NO sean iguales a "Local", ¿cuál es el criterio correcto?

7

Si quieres usar el valor de la celda G1 como criterio, ¿cómo se debe escribir en la fórmula?

8

¿Cuál es el límite de criterios que puede manejar la función SUMAR.SI simple?

9

¿Cuál es la principal diferencia de sintaxis entre SUMAR.SI y SUMAR.SI.CONJUNTO respecto al rango de suma?

10

¿Qué operador lógico aplica implícitamente la función SUMAR.SI.CONJUNTO entre sus múltiples criterios?

 
Are you sure you want to leave the page?

If you leave, you will lose the game in progress.