{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Cover","SUMME","SUMMEWENN","SUMMEWENNS","DBSUMME"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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","Summenfunktionen"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Version","1.0"]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum","2025-04-25"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"SUMME","index":1,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Warengruppe","Januar"]
["A",13200]
["B",15600]
["C",12500]
["D",7800]
["Gesamtumsatz",{"$f":"SUM(Januar)","v":{"$error":"#NAME?"}}]

{"sheet":"SUMMEWENN","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Auftraggeber","Umsatz"]
["A",10000]
["B",5000]
["C",25000]
["A",18500]
["C",3000]
[]
["Kunde","A"]
["Umsatz",{"$f":"SUMIF(Auftraggeber,Kunde,Umsatz)","v":{"$error":"#NAME?"}}]
["Umsatz < 15000",{"$f":"SUMIF(Umsatz,\"<13500\")","v":{"$error":"#NAME?"}}]

{"sheet":"SUMMEWENNS","index":3,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Kunde","Land","Stadt","Jahresumsatz"]
["A","Deutschland","Berlin",750599]
["B","Österreich","Basel",298764]
["C","Schweiz","Zug",118563]
["D","Niederlande","Den Haag",55198]
["E","Deutschland","Frankfurt",861634]
["C","Frankreich","Lyon",1560678]
["D","Deutschland","Köln",46200]
["C","Schweiz","Bern",112456]
[]
["Kunde","C"]
["Land","Schweiz"]
["Umsatz",231019]

{"sheet":"DBSUMME","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Kunde","Land","Stadt","Jahresumsatz","Aufträge"]
["A","Deutschland","Berlin",750599,6]
["B ","Schweiz","Zug",298764,3]
["C","Österreich","Wien",118563,2]
["D","Niederlande","Den Haag",55198,4]
["E","Deutschland","Frankfurt",861634,7]
["F","Frankreich","Lyon",1560678,9]
["G","Deutschland","Köln",46200,3]
["H","Belgien","Brüssel",643560,8]
[]
["Kunde","Land","Stadt","Jahresumsatz","Aufträge"]
[null,"Deutschland",null,">500000",">5"]
[null,null,null,{"$f":"DSUM(_xlnm.Database,Suche,Kriterien)","v":1612233}]