Dwa wymiary: produkty w wierszach, klasy w kolumnach

Tabele i wykresy przestawne - Arkusz kalkulacyjny w liceum i technikum (sheet)

Tabela przestawna może grupować w dwóch kierunkach naraz. W arkuszu **Zestawienie** produkty są w **wierszach**, klasy w **kolumnach**, a na przecięciu jest **Suma z Sztuk**. Ostatnia kolumna i ostatni wiersz to sumy końcowe. Puste pole oznacza, że ta klasa nie sprzedawała tego produktu. Takie samo zestawienie zbudowane formułami wymagałoby `SUMA.WARUNKÓW` w każdej komórce. Pole kolumn działa przy jednej wartości. Działanie wartości zmienisz na **Liczba** (ile transakcji), **Średnia**, **Minimum** albo **Maksimum**.

{"sheets":[{"name":"Dane","cells":{"A1":"Klasa","B1":"Produkt","C1":"Sztuk","D1":"Kwota","A2":"1a","B2":"ciasto","C2":"12","D2":"48","A3":"1b","B3":"lemoniada","C3":"20","D3":"60","A4":"2a","B4":"kanapki","C4":"15","D4":"45","A5":"1a","B5":"lemoniada","C5":"18","D5":"54","A6":"1b","B6":"ciasto","C6":"9","D6":"36","A7":"2a","B7":"muffinki","C7":"14","D7":"56","A8":"1a","B8":"kanapki","C8":"10","D8":"30","A9":"2a","B9":"lemoniada","C9":"22","D9":"66","A10":"1b","B10":"muffinki","C10":"11","D10":"44","A11":"2a","B11":"ciasto","C11":"7","D11":"28","A12":"1a","B12":"muffinki","C12":"16","D12":"64","A13":"1b","B13":"kanapki","C13":"13","D13":"39","A14":"2a","B14":"kanapki","C14":"8","D14":"24","A15":"1a","B15":"lemoniada","C15":"6","D15":"18","A16":"1b","B16":"ciasto","C16":"5","D16":"20","A17":"2a","B17":"muffinki","C17":"9","D17":"36","A18":"1a","B18":"ciasto","C18":"4","D18":"16","A19":"1b","B19":"lemoniada","C19":"12","D19":"36"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"D1":{"bold":true,"fill":"#e0e7ff"}},"cols":{"B":90,"G":120},"freeze":{"rows":1,"cols":0}},{"name":"Zestawienie","cells":{"A1":"Suma z Sztuk","B1":"Klasa","A2":"Produkt","B2":"1a","C2":"1b","D2":"2a","E2":"Suma końcowa","A3":"ciasto","B3":"16","C3":"14","D3":"7","E3":"37","A4":"kanapki","B4":"10","C4":"13","D4":"23","E4":"46","A5":"lemoniada","B5":"24","C5":"32","D5":"22","E5":"78","A6":"muffinki","B6":"16","C6":"11","D6":"23","E6":"50","A7":"Suma końcowa","B7":"66","C7":"70","D7":"75","E7":"211"},"formats":{"A1":{"bold":true},"B1":{"bold":true},"A2":{"bold":true},"B2":{"bold":true},"C2":{"bold":true},"D2":{"bold":true},"E2":{"bold":true},"A7":{"bold":true},"B7":{"bold":true},"C7":{"bold":true},"D7":{"bold":true},"E7":{"bold":true}},"cols":{"A":120},"pivots":[{"source":"A1:D19","at":"A1","values":[{"field":"C","agg":"sum"}],"sourceSheet":"Dane","rows":"B","cols":"A","size":{"rows":7,"cols":5}}]}]}

Ł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.