← Búsquedas y lógica
Lección 3 de 5
SUMIFS and COUNTIFS: totals with conditions
Lo que podrás hacer
Total and count rows meeting one or several criteria, and get the argument order right first time.
"How much did Brookside do in Tools last quarter?" is the most common question anyone will ever ask you about a spreadsheet. Two functions answer almost every version of it.
0 XP
Paso 1 de 6 · 1 punto
Total the line totals for the Brookside branch.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ||||||||||
| 2 | ||||||||||
| 3 | ||||||||||
| 4 | ||||||||||
| 5 | ||||||||||
| 6 | ||||||||||
| 7 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 | ||||||||||
| 11 | ||||||||||
| 12 | ||||||||||
| 13 | ||||||||||
| 14 |
Haz clic y arrastra sobre las celdas para ver aquí su Promedio, Recuento y Suma.
Rows 1 to 14 of 315
Name Box (Cuadro de nombres)Q2fx