{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Data Set","SUM Function","SUM inside ABS","2 SUMIF Functions","SUM & SUMIF Functions","SUMIF Function","VBA Macro"],"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":"Data Set","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Sample Dataset"]
[]
[null,"Number List"]
[null,15]
[null,6]
[null,-9]
[null,8]
[null,-10]

{"sheet":"SUM Function","index":1,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of SUM Function",null,null,null,"Practice Section>>"]
[]
[null,"Number List",null,null,null,"Number List"]
[null,15,null,null,null,15]
[null,6,null,null,null,6]
[null,-9,null,null,null,-9]
[null,8,null,null,null,8]
[null,-10,null,null,null,-10]
[]
[null,"Total",null,null,null,"Total"]
[null,{"$f":"SUM(ABS(B5:B9))","v":48}]

{"sheet":"SUM inside ABS","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of SUM Function Inside ABS",null,null,null,"Practice Section>>"]
[]
[null,"Number List",null,null,null,"Number List"]
[null,-15,null,null,null,-15]
[null,6,null,null,null,6]
[null,-9,null,null,null,-9]
[null,8,null,null,null,8]
[null,-10,null,null,null,-10]
[]
[null,"Total",null,null,null,"Total"]
[null,{"$f":"ABS(SUM(B5:B9))","v":20}]

{"sheet":"2 SUMIF Functions","index":3,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Combining 2 SUMIF Functions",null,null,null,"Practice Section>>"]
[]
[null,"Number List",null,null,null,"Number List"]
[null,15,null,null,null,15]
[null,6,null,null,null,6]
[null,-9,null,null,null,-9]
[null,8,null,null,null,8]
[null,-10,null,null,null,-10]
[]
[null,"Total",null,null,null,"Total"]
[null,{"$f":"SUMIF(B5:B9,\">0\")-SUMIF(B5:B9,\"<0\")","v":48}]

{"sheet":"SUM & SUMIF Functions","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Combination of SUM & SUMIF Functions",null,null,null,"Practice Section>>"]
[]
[null,"Number List",null,null,null,"Number List"]
[null,15,null,null,null,15]
[null,6,null,null,null,6]
[null,-9,null,null,null,-9]
[null,8,null,null,null,8]
[null,-10,null,null,null,-10]
[]
[null,"Total",null,null,null,"Total"]
[null,{"$f":"SUM(SUMIF(B5:B9,{\">0\",\"<0\"})*{1,-1})","v":48}]

{"sheet":"SUMIF Function","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of SUMIF Function",null,null,null,"Practice Section>>"]
[]
[null,"Number List 1","Number List 2",null,null,"Number List 1"]
[null,15,25,null,null,15]
[null,6,-60,null,null,6]
[null,-9,10,null,null,-9]
[null,8,-20,null,null,8]
[null,-10,50,null,null,-10]
[]
[null,"Total",{"$f":"ABS(SUMIF(B5:B9,\">0\")+SUMIF(C5:C9,\"<0\"))","v":51},null,null,"Total"]

{"sheet":"VBA Macro","index":6,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of VBA Macro",null,null,null,"Practice Section>>"]
[]
[null,"Number List",null,null,null,"Number List"]
[null,15,null,null,null,15]
[null,6,null,null,null,6]
[null,-9,null,null,null,-9]
[null,8,null,null,null,8]
[null,-10,null,null,null,-10]
[]
[null,"Total",null,null,null,"Total"]
[null,{"$f":"ABS_SUM(B5:B9)","v":48}]