{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Cover","ANZAHL","ZÄHLENWENN","ZÄHLENWENNS","ZEILE & SPALTE","ADRESSE"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover","index":0,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",3]
[null,"Thema","Formeln und Funktionen"]
[]
[null,"Inhalt","Zählfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"ANZAHL","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt"]
["2023-02-12",21300,"P2"]
["2023-03-16",35600,"P1"]
["2023-04-11",32700,"P3"]
["2023-04-21","storniert","P2"]
["2023-05-15",28900,"P1"]
["2023-06-13",31200,"P2"]
["2023-07-17",29700,"P3"]
[]
["Anzahl Werte",{"$f":"COUNT(Umsatz)","v":0}]
["Anzahl Umsätze",{"$f":"COUNTA(Umsatz)","v":1}]
["Anzahl Produkte",{"$f":"COUNTA(Produkt)","v":1}]

{"sheet":"ZÄHLENWENN","index":2,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Datum","Umsatz","Produkt"]
["2023-02-12",21300,"P2"]
["2023-03-16",35600,"P1"]
["2023-04-11",32700,"P3"]
["2023-04-21","storniert","P2"]
["2023-05-15",28900,"P1"]
["2023-06-13",31200,"P2"]
["2023-07-17",29700,"P3"]
[]
["Anzahl P2",{"$f":"COUNTIF(Produkt,\"P2\")","v":{"$error":"#NAME?"}}]
["Anzahl Umsatz>32000",{"$f":"COUNTIF(Umsatz,\">32000\")","v":{"$error":"#NAME?"}}]

{"sheet":"ZÄHLENWENNS","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar","Februar","März"]
["A",13450,14560,19300]
["B",18230,17450,18350]
["C",15440,16210,15390]
["D",9870,8730,8920]
["E",12700,10300,17200]
["F",16700,12500,13300]
[]
["Anzahl Umsätze",{"$f":"COUNTIFS(Jan,\">=15000\",Feb,\">=16000\",Mrz,\">=17000\")","v":{"$error":"#NAME?"}}]
["Jan=>15.000",{"$f":"COUNTIFS(Jan,\">=15000\")","v":{"$error":"#NAME?"}}]
["Feb=>16.000",{"$f":"COUNTIFS(Feb,\">=16000\")","v":{"$error":"#NAME?"}}]
["Mrz=>17.000",{"$f":"COUNTIFS(Mrz,\">=17000\")","v":{"$error":"#NAME?"}}]

{"sheet":"ZEILE & SPALTE","index":4,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Januar",432,1120,1436]
["Februar",382,null,234]
["März",611,105,656]
["April",160,213]
["Mai",988,899,256]
["Juni",743,654,347]
["Juli",854,436,675]
["August",812,1098,238]
["September",null,199,217]
["Oktober",366,437,459]
["November",310,565,378]
["Dezember",744,345,645]
[]
["Zeile","Spalte"]
[{"$f":"ROW($C$3)","v":3},{"$f":"COLUMN($C$3)","v":3}]
[{"$f":"ROW($D$5)","v":5},{"$f":"COLUMN($D$5)","v":4}]
[{"$f":"ROW($B$10)","v":10},{"$f":"COLUMN($B$10)","v":2}]

{"sheet":"ADRESSE","index":5,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Monat","Produkt1","Produkt2","Produkt3"]
["Januar",432,1120,1436]
["Februar",382,null,234]
["März",611,105,656]
["April",160,213]
["Mai",988,899,256]
["Juni",743,654,347]
["Juli",854,436,675]
["August",812,1098,238]
["September",null,199,217]
["Oktober",366,437,459]
["November",310,565,378]
["Dezember",744,345,645]