A filter on the arrow is not enough
Basic filter: one arrow, one condition. “Only grades 1.” An advanced filter (in Sheets Filter by condition, in Excel Advanced filter) can do: grades 1 or 2, spending between 10 and 50 Kč, text contains “apple”.
The Sorter does not count — it picks the rows that match the rule. Leave counting to KDYŽ and the summary table.
Conditions on grades and the survey
-
Sheet
Znamky. Filter already on (row 1). Click the arrow at Grade. Filter by condition. -
Condition: Is greater than or equal to
2AND Is less than or equal to3— in Sheets two conditions on one column (Custom formula:=AND(B2>=2;B2<=3)on a range with a header). You will see only twos and threes. -
Reset the filter — select all. Second condition: Text contains on the Subject column — type
a. Maths, English stay… -
Sheet with the survey. Answer column. Condition Equals
apple— only rows with apples. Count the visible rows (status at the bottom in Sheets) = number of votes for apple. -
After every exercise put the filter back — select all. Hidden rows do not count into SUM, if you accidentally sum the column.
An advanced filter must not be on when you hand in, if the teacher should see all the data. Before PDF: turn the filter off or “Select all”. Hidden rows look like the data vanished.
A custom formula in the filter
Sheets: Filter by condition → Custom formula is. For column B (grades) from row 2: =B2<=2 — only ones and twos (better grades). The formula must point at the first data row in that column (B2), not B1.
What often goes wrong
Filter on, SUM empty. You are summing a filtered column and you wonder. Turn the filter off or sum only the visible cells on purpose (SUBTOTAL comes later).
Two conditions OR instead of AND. You want apple OR roll — in Sheets tick two values in the filter, not AND on one text.
Forgotten reset. Tomorrow you open the table and rows are missing. Always check the filter icon.
🏫 Grade average — only worse
Filter grades ≥3. You see where to talk it through. The average in B8 changes when you count only the visible ones — watch out. For the real average turn the filter off. A filter is a tool for the eyes, not for the final number.
💰 Pocket money — spending over the limit
Filter C > 30. Which days burn the most? Compare with D (Left) on the same rows.
📊 Class survey — counting votes
Filter on one answer + count of visible rows = votes for that answer. Before the summary table — this is how you check that the summary fits.
🏆 Mini dashboard — filter off
On the dashboard no filter. The dashboard shows a summary of the whole project. Use the filter for cleaning and checking, not in the hand-in.
Now you 💪
First: grades — filter only 2 and 3. Count the rows. Reset.
Second: survey — filter apple, count of visible. Reset.
Check: After the exercise you see all the rows. You know the difference between a filter for checking and the final table.
What to take from this lesson
- Advanced filter = more conditions, a custom formula.
- After work turn the filter off — hidden rows confuse.
- Filter for checking, summary table for the chart.
© 2026 Ing. Martin Polak / AlgoRhino · Content usage terms