Cargando ejercicio…
Cargando ejercicio…
Los ejercicios están pensados para usar con teclado. Lee la tarea aquí y luego abre esta página en una computadora para resolverla.
Operaciones quiere saber cuántos pedidos de julio de esta muestra se completaron en West.
En F2, cuenta los pedidos donde Region es West y Status es completed.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Region | Status | Channel | Completed West orders | |||
| 2 | 50545 | South | completed | Sales Rep | ||||
| 3 | 50546 | South | completed | Sales Rep | ||||
| 4 | 50547 | West | completed | Sales Rep | ||||
| 5 | 50548 | South | completed | Sales Rep | ||||
| 6 | 50549 | South | completed | Partner | ||||
| 7 | 50550 | East | refunded | Sales Rep | ||||
| 8 | 50551 | North | completed | Sales Rep | ||||
| 9 | 50552 | West | completed | Sales Rep | ||||
| 10 | 50553 | North | completed | Online | ||||
| 11 | 50554 | West | completed | Sales Rep | ||||
| 12 | 50555 | North | completed | Online | ||||
| 13 | 50556 | South | completed | Sales Rep | ||||
| 14 | 50557 | South | completed | Partner | ||||
| 15 | 50558 | East | completed | Sales Rep | ||||
| 16 | 50559 | North | completed | Online | ||||
| 17 | 50560 | North | completed | Sales Rep | ||||
| 18 | 50561 | North | completed | Sales Rep | ||||
| 19 | 50562 | South | completed | Partner | ||||
| 20 | 50563 | East | completed | Partner | ||||
| 21 | 50564 | East | completed | Online | ||||
| 22 | ||||||||
| 23 | ||||||||
| 24 |
=SI(B2>=1,5;SUMA(C2:C9);0)Idioma
Plan completo
Excel ✓ · SQL y Power BI también incluidos
Cancela cuando quieras · Reembolso total en 14 días · Pago seguro con Stripe