{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset"," Utilize Algebraic Sum","Use Excel's SUM function"," Sum if certain text in cell","Using SUMIF function","Using AUTOSUM","Using CONCAT","Using 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":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary"]
[null,"Robert",600]
[null,"Smith",700]
[null,"John",750]
[null,"Tom",750]
[null,"Jessica",750]
[null,"Peter",500]
[null,"Tom",500]

{"sheet":" Utilize Algebraic Sum","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary"]
[null,"Robert",600]
[null,"Smith",700]
[null,"John",750]
[null,"Tom",750]
[null,"Jessica",750]
[null,"Peter",500]
[null,"Tom",500]
[null,"Total",{"$f":"C6+C7+C8+C9+C10+C11+C12","v":4550}]

{"sheet":"Use Excel's SUM function","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary"]
[null,"Robert",600]
[null,"Smith",700]
[null,"John",750]
[null,"Tom",750]
[null,"Jessica",750]
[null,"Peter",500]
[null,"Tom",500]
[null,"Total",{"$f":"SUM(C6:C12)","v":4550}]

{"sheet":" Sum if certain text in cell","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary"]
[null,"Robert",600]
[null,"Smith",700]
[null,"John",750]
[null,"Tom",750]
[null,"Jessica",750]
[null,"Peter",500]
[null,"Tom",500]
[null,"Total",{"$f":"SUMIF(B6:B12,\"*Tom*\",C6:C12)","v":1250}]

{"sheet":"Using SUMIF function","index":4,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary"]
[null,"Robert",600]
[null,"Smith",700]
[null,"John",750]
[null,"Tom",750]
[null,"Jessica",750]
[null,"Peter",500]
[null,"Tom",500]
[null,"Total",{"$f":"SUMIF(C6:C12,\">700\")","v":2250}]

{"sheet":"Using AUTOSUM","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary"]
[null,"Robert",600]
[null,"Smith",700]
[null,"John",750]
[null,"Tom",750]
[null,"Jessica",750]
[null,"Peter",500]
[null,"Tom",500]
[null,"Total",{"$f":"SUM(C6:C12)","v":4550}]

{"sheet":"Using CONCAT","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","Total Salary","Result"]
[null,"Robert",600,{"$f":"_xlfn.CONCAT(B6, \" \",C6)","v":"Robert 600"}]
[null,"Smith",700,{"$f":"_xlfn.CONCAT(B7, \" \",C7)","v":"Smith 700"}]
[null,"John",750,"John 750"]
[null,"Tom",750,"Tom 750"]
[null,"Jessica",750,"Jessica 750"]
[null,"Peter",500,"Peter 500"]
[null,"Tom",500,"Tom 500"]

{"sheet":"Using VBA","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,2,4]]}
[]
[]
[null,"Adding Specific Cells in Excel"]
[]
[null,"Name of Employee","March Sale","April Sale","Total Sale"]
[null,"Robert",600,800,1400]
[null,"Smith",700,450,1150]
[null,"John",750,550,1300]
[null,"Tom",750,750,1500]
[null,"Jessica",750,550,1300]
[null,"Peter",500,650,1150]
[null,"Tom",500,750,1250]