{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Single_Numeric","Single_Text","Multi_Criteria","SUMIF_VBA","SUMIF_VBA_Formula","SUMIFS","SUMIFS_VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Dataset","index":0,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Dataset for Using SUMIF with Not Equal Criteria"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]

{"sheet":"Single_Numeric","index":1,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Sum with Numeric Not Equal Single Criteria"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria",250]
[null,"Conditional Sum",{"$f":"SUMIF(E5:E17, \"<>250\",F5:F17)","v":15050}]

{"sheet":"Single_Text","index":2,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Sum with Text Not Equal Single Criteria"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria","Navada"]
[null,"Conditional Sum",{"$f":"SUMIF(D5:D17, \"<>Navada\",F5:F17)","v":17600}]

{"sheet":"Multi_Criteria","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5],[19,2,19,3]]}
[]
[null,"Calculating Sum with Multiple Not Equal Criteria"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria","Navada",250]
[null,"Conditional Sum",{"$f":"SUMIF(D5:D17, \"<>Navada\",F5:F17)+SUMIF(E5:E17, \"<>250\",F5:F17)","v":32650}]

{"sheet":"SUMIF_VBA","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Sum with Not Equal Single Criteria Using VBA"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria","Navada"]
[null,"Conditional Sum",17600]

{"sheet":"SUMIF_VBA_Formula","index":5,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Calculating Sum with Not Equal Single Criteria Using VBA"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria","Navada"]
[null,"Conditional Sum",17600]

{"sheet":"SUMIFS","index":6,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5],[19,2,19,3]]}
[]
[null,"Calculating Sum with Multiple Not Equal Criteria Using SUMIFS"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria","Navada",250]
[null,"Conditional Sum",{"$f":"SUMIFS(F5:F17,D5:D17,\"<>Navada\",E5:E17,\"<>250\")","v":13860}]

{"sheet":"SUMIFS_VBA","index":7,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,5],[19,2,19,3]]}
[]
[null,"Calculating Sum with Multiple Not Equal Criteria Using SUMIFS"]
[]
[null,"Employee ID","Name","State","Sales Unit","Sales"]
[null,11021499,"Michael","Michigan",200,1300]
[null,13426745,"Scofield","Navada",250,1900]
[null,12454678,"Jonathan","New York",150,1750]
[null,16743625,"Wick","Wasington D.C",400,1250]
[null,12746538,"Pablo","Michigan",150,1620]
[null,16453623,"Escober","Navada",100,1190]
[null,12236465,"Miguel","California",300,1840]
[null,13453657,"Sherlock","New York",150,1720]
[null,14536745,"Watson","Chicago",300,1340]
[null,13786546,"David","Michigan",200,1110]
[null,13244567,"Samanta","Texas",100,1930]
[null,15345278,"Walter","New York",250,1990]
[null,12866767,"Ronaldo","Michigan",250,1750]
[]
[null,"Not Equal Criteria","Navada",250]
[null,"Conditional Sum",13860]