{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["With Table","With Filter","With Filter2","AutoSum","With VBA","SUMIF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":"With Table","index":0,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"With Table",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Hour/Day","Salary",null,null,null,null,null,"Employee","Department","Hour/Day","Salary"]
[null,"Mike","Marketing",7,2000,null,null,null,null,null,"Mike","Marketing",7,2000]
[null,"Sophie","Accounting",8,2200,null,null,null,null,null,"Sophie","Accounting",8,2200]
[null,"Chris","Accounting",8,2200,null,null,null,null,null,"Chris","Accounting",8,2200]
[null,"Paul","Marketing",7,2000,null,null,null,null,null,"Paul","Marketing",7,2000]
[null,"Andrew","IT",6,2400,null,null,null,null,null,"Andrew","IT",6,2400]
[null,"Josh","Accounting",8,2200,null,null,null,null,null,"Josh","Accounting",8,2200]
[null,"Carry","IT",6,2400,null,null,null,null,null,"Carry","IT",6,2400]
[null,"Alexa","Marketing",7,2200,null,null,null,null,null,"Alexa","Marketing",7,2200]
[null,"Total",null,null,{"$f":"SUBTOTAL(109,Table1[Salary])","v":17600},null,null,null,null,null,"Total"]

{"sheet":"With Filter","index":1,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,9,1,12]]}
[]
[null,"Use of SUBTOTAL Function",null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Hour/Day","Salary",null,null,null,null,"Employee","Department","Hour/Day","Salary"]
[null,"Mike","Marketing",7,2000,null,null,null,null,"Mike","Marketing",7,2000]
[null,"Sophie","Accounting",8,2200,null,null,null,null,"Sophie","Accounting",8,2200]
[null,"Chris","Accounting",8,2200,null,null,null,null,"Chris","Accounting",8,2200]
[null,"Paul","Marketing",7,2000,null,null,null,null,"Paul","Marketing",7,2000]
[null,"Andrew","IT",6,2400,null,null,null,null,"Andrew","IT",6,2400]
[null,"Josh","Accounting",8,2200,null,null,null,null,"Josh","Accounting",8,2200]
[null,"Carry","IT",6,2400,null,null,null,null,"Carry","IT",6,2400]
[null,"Alexa","Marketing",7,2200,null,null,null,null,"Alexa","Marketing",7,2200]
[null,"TOTAL",null,null,{"$f":"SUBTOTAL(109,E5:E12)","v":17600},null,null,null,null,"TOTAL"]

{"sheet":"With Filter2","index":2,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"Use of AGGREGATE Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Hour/Day","Salary",null,null,null,null,null,"Employee","Department","Hour/Day","Salary"]
[null,"Mike","Marketing",7,2000,null,null,null,null,null,"Mike","Marketing",7,2000]
[null,"Sophie","Accounting",8,2200,null,null,null,null,null,"Sophie","Accounting",8,2200]
[null,"Chris","Accounting",8,2200,null,null,null,null,null,"Chris","Accounting",8,2200]
[null,"Paul","Marketing",7,2000,null,null,null,null,null,"Paul","Marketing",7,2000]
[null,"Andrew","IT",6,2400,null,null,null,null,null,"Andrew","IT",6,2400]
[null,"Josh","Accounting",8,2200,null,null,null,null,null,"Josh","Accounting",8,2200]
[null,"Carry","IT",6,2400,null,null,null,null,null,"Carry","IT",6,2400]
[null,"Alexa","Marketing",7,2200,null,null,null,null,null,"Alexa","Marketing",7,2200]
[null,"TOTAL",null,null,{"$f":"_xlfn.AGGREGATE(9,5,E5:E12)","v":17600},null,null,null,null,null,"TOTAL"]

{"sheet":"AutoSum","index":3,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"With Filter & AutoSum",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Hour/Day","Salary",null,null,null,null,null,"Employee","Department","Hour/Day","Salary"]
[null,"Mike","Marketing",7,2000,null,null,null,null,null,"Mike","Marketing",7,2000]
[null,"Sophie","Accounting",8,2200,null,null,null,null,null,"Sophie","Accounting",8,2200]
[null,"Chris","Accounting",8,2200,null,null,null,null,null,"Chris","Accounting",8,2200]
[null,"Paul","Marketing",7,2000,null,null,null,null,null,"Paul","Marketing",7,2000]
[null,"Andrew","IT",6,2400,null,null,null,null,null,"Andrew","IT",6,2400]
[null,"Josh","Accounting",8,2200,null,null,null,null,null,"Josh","Accounting",8,2200]
[null,"Carry","IT",6,2400,null,null,null,null,null,"Carry","IT",6,2400]
[null,"Alexa","Marketing",7,2200,null,null,null,null,null,"Alexa","Marketing",7,2200]
[null,"TOTAL",null,null,{"$f":"SUM(E5:E12)","v":17600},null,null,null,null,null,"TOTAL"]

{"sheet":"With VBA","index":4,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,10,1,13]]}
[]
[null,"With VBA",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Hour/Day","Salary",null,null,null,null,null,"Employee","Department","Hour/Day","Salary"]
[null,"Mike","Marketing",7,2000,null,null,null,null,null,"Mike","Marketing",7,2000]
[null,"Sophie","Accounting",8,2200,null,null,null,null,null,"Sophie","Accounting",8,2200]
[null,"Chris","Accounting",8,2200,null,null,null,null,null,"Chris","Accounting",8,2200]
[null,"Paul","Marketing",7,2000,null,null,null,null,null,"Paul","Marketing",7,2000]
[null,"Andrew","IT",6,2400,null,null,null,null,null,"Andrew","IT",6,2400]
[null,"Josh","Accounting",8,2200,null,null,null,null,null,"Josh","Accounting",8,2200]
[null,"Carry","IT",6,2400,null,null,null,null,null,"Carry","IT",6,2400]
[null,"Alexa","Marketing",7,2200,null,null,null,null,null,"Alexa","Marketing",7,2200]
[null,"TOTAL",null,null,{"$f":"onlyvisible(E5:E12)","v":17600},null,null,null,null,null,"TOTAL"]

{"sheet":"SUMIF","index":5,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,10,1,14]]}
[]
[null,"With SUMIF Function",null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","Yes/No \nColumn","Salary","Helper",null,null,null,null,"Employee","Department","Yes/No \nColumn","Salary","Helper"]
[null,"Mike","Marketing","Yes",2000,{"$f":"_xlfn.AGGREGATE(9,5,E5)","v":2000},null,null,null,null,"Mike","Marketing","Yes",2000,{"$f":"_xlfn.AGGREGATE(9,5,N5)","v":2000}]
[null,"Sophie","Accounting","No",2200,{"$f":"_xlfn.AGGREGATE(9,5,E6)","v":2200},null,null,null,null,"Sophie","Accounting","No",2200,{"$f":"_xlfn.AGGREGATE(9,5,N6)","v":2200}]
[null,"Chris","Accounting","Yes",2200,2200,null,null,null,null,"Chris","Accounting","Yes",2200,2200]
[null,"Paul","Marketing","No",2000,2000,null,null,null,null,"Paul","Marketing","No",2000,2000]
[null,"Andrew","IT","No",2400,2400,null,null,null,null,"Andrew","IT","No",2400,2400]
[null,"Josh","Accounting","Yes",2200,2200,null,null,null,null,"Josh","Accounting","Yes",2200,2200]
[null,"Carry","IT","Yes",2400,2400,null,null,null,null,"Carry","IT","Yes",2400,2400]
[null,"Alexa","Marketing","No",2200,2200,null,null,null,null,"Alexa","Marketing","No",2200,2200]
[null,"TOTAL",null,null," ",{"$f":"SUMIF(D5:D12,\"Yes\",F5:F12)","v":8800},null,null,null,null,"TOTAL",null,null," "]