Zestawienie w dwóch wymiarach

Zestawienia danych: sumy i średnie według kategorii - Arkusz kalkulacyjny w liceum i technikum (sheet)

Wiersze to kategorie, kolumny miesiące, a na przecięciu suma sprzedaży. Jedna formuła z adresami mieszanymi wypełnia całą tabelę: `=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E2;$A$2:$A$17;F$1)` `$E2` to zawsze kategoria z kolumny E, `F$1` zawsze miesiąc z wiersza 1. Tak wygląda tabela przestawna z kategorią w wierszach i miesiącem w kolumnach.

{"sheets":[{"name":"Arkusz1","cells":{"A1":"Miesiąc","B1":"Kategoria","C1":"Wartość","A2":"styczeń","B2":"owoce","C2":"320","A3":"styczeń","B3":"warzywa","C3":"210","A4":"styczeń","B4":"nabiał","C4":"450","A5":"styczeń","B5":"pieczywo","C5":"180","A6":"styczeń","B6":"owoce","C6":"140","A7":"luty","B7":"warzywa","C7":"260","A8":"luty","B8":"nabiał","C8":"390","A9":"luty","B9":"owoce","C9":"300","A10":"luty","B10":"pieczywo","C10":"220","A11":"luty","B11":"nabiał","C11":"160","A12":"marzec","B12":"owoce","C12":"410","A13":"marzec","B13":"warzywa","C13":"290","A14":"marzec","B14":"pieczywo","C14":"205","A15":"marzec","B15":"nabiał","C15":"430","A16":"marzec","B16":"warzywa","C16":"120","A17":"marzec","B17":"owoce","C17":"95","E1":"Kategoria","F1":"styczeń","G1":"luty","H1":"marzec","E2":"owoce","E3":"warzywa","E4":"nabiał","E5":"pieczywo","F2":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E2;$A$2:$A$17;F$1)","G2":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E2;$A$2:$A$17;G$1)","H2":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E2;$A$2:$A$17;H$1)","F3":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E3;$A$2:$A$17;F$1)","G3":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E3;$A$2:$A$17;G$1)","H3":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E3;$A$2:$A$17;H$1)","F4":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E4;$A$2:$A$17;F$1)","G4":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E4;$A$2:$A$17;G$1)","H4":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E4;$A$2:$A$17;H$1)","F5":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E5;$A$2:$A$17;F$1)","G5":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E5;$A$2:$A$17;G$1)","H5":"=SUMA.WARUNKÓW($C$2:$C$17;$B$2:$B$17;$E5;$A$2:$A$17;H$1)"},"formats":{"A1":{"bold":true,"fill":"#e0e7ff"},"B1":{"bold":true,"fill":"#e0e7ff"},"C1":{"bold":true,"fill":"#e0e7ff"},"E1":{"bold":true,"fill":"#e0e7ff"},"F1":{"bold":true,"fill":"#e0e7ff"},"G1":{"bold":true,"fill":"#e0e7ff"},"H1":{"bold":true,"fill":"#e0e7ff"}},"cols":{"A":90,"B":90,"E":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.