← Nachschlagen und Logik
Lektion 3 von 5
SUMIFS and COUNTIFS: totals with conditions
Was du danach kannst
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
Schritt 1 von 6 · 1 Punkt
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 |
Klicken und ziehen Sie über Zellen, um hier Mittelwert, Anzahl und Summe zu sehen.
Rows 1 to 14 of 315
Name Box (Namenfeld)Q2fx