To samo pytanie formułą

Filtrowanie według kilku kryteriów - Arkusz kalkulacyjny w liceum i technikum (sheet)

`LICZ.WARUNKI` przyjmuje pary: zakres i kryterium. `=LICZ.WARUNKI(B2:B15;"Kraków";E2:E15;">=70")` liczy wiersze, w których jednocześnie miasto to Kraków, a wartość wynosi co najmniej 70. `SUMA.WARUNKÓW` najpierw dostaje zakres do sumowania, potem pary kryteriów. Kryterium może odwoływać się do komórki: `">="&H1`.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Data","B1":"Miasto","C1":"Produkt","D1":"Ilość","E1":"Wartość","A2":"02.11.2026","B2":"Kraków","C2":"kawa","D2":"4","E2":"96","A3":"02.11.2026","B3":"Gdańsk","C3":"herbata","D3":"2","E3":"30","A4":"03.11.2026","B4":"Wrocław","C4":"kawa","D4":"7","E4":"168","A5":"03.11.2026","B5":"Kraków","C5":"herbata","D5":"5","E5":"75","A6":"04.11.2026","B6":"Kraków","C6":"kawa","D6":"2","E6":"48","A7":"04.11.2026","B7":"Poznań","C7":"kakao","D7":"3","E7":"54","A8":"05.11.2026","B8":"Gdańsk","C8":"kawa","D8":"6","E8":"144","A9":"05.11.2026","B9":"Wrocław","C9":"herbata","D9":"1","E9":"15","A10":"06.11.2026","B10":"Kraków","C10":"kakao","D10":"8","E10":"144","A11":"06.11.2026","B11":"Gdańsk","C11":"kakao","D11":"2","E11":"36","A12":"09.11.2026","B12":"Poznań","C12":"kawa","D12":"5","E12":"120","A13":"09.11.2026","B13":"Kraków","C13":"kawa","D13":"3","E13":"72","A14":"10.11.2026","B14":"Wrocław","C14":"kakao","D14":"4","E14":"72","A15":"10.11.2026","B15":"Gdańsk","C15":"herbata","D15":"9","E15":"135","G2":"Liczba","H2":"=LICZ.WARUNKI(B2:B15;\"Kraków\";E2:E15;\">=70\")","G3":"Suma","H3":"=SUMA.WARUNKÓW(E2:E15;B2:B15;\"Kraków\";E2:E15;\">=70\")"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"},"E1":{"bold":true,"fill":"#e0e7ff"},"G2":{"bold":true},"G3":{"bold":true}},"cols":{"A":100}}]}

Ładowanie interaktywnego edytora... Jeśli się nie pojawi, włącz JavaScript.

Wszystkie lekcje kursu Arkusz kalkulacyjny w liceum i technikum·Zaloguj się, aby zapisać postęp na koncie.