{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Half yearly","Yearly","Half yearly 2","Sumifs function","Sumproduct function","Sumif diff column","Sumif vlookup"],"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":"Half yearly","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Half Yearly Number Sheet"]
[]
[null,"Name","Student Class","Obtained Mark"]
[null,"Roben",9,80]
[null,"James",10,85]
[null,"David",9,72]
[null,"John",9,65]
[null,"Simon",10,90]

{"sheet":"Yearly","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Full Yearly Number Sheet"]
[]
[null,"Name","Student Class","Obtained Mark"]
[null,"Roben",9,70]
[null,"James",10,60]
[null,"David",9,80]
[null,"John",9,80]
[null,"Simon",10,70]

{"sheet":"Half yearly 2","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[" ","Half Yearly Number Sheet "]
[]
[null,"Name","Student Class","Obtained Mark"]
[null,"Robin",9,80]
[null,"James",10,85]
[null,"David",9,72]
[null,"John",9,65]
[null,"Simon",10,90]

{"sheet":"Sumifs function","index":3,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,1,2,2],[9,7,9,8]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"S"]
[null,"Student Number Sheet"]
[]
[null," Class",9]
[]
[null,"Student","Total Mark"]
[null,"Roben",{"$f":"SUMIFS('Half yearly'!D6:D10,'Half yearly'!B6:B10,'Sumifs function'!B8,\n'Half yearly'!C6:C10,'Sumifs function'!$C$5)+\nSUMIFS(Yearly!D6:D10,Yearly!B6:B10,'Sumifs function'!B8,Yearly!C6:C10,'Sumifs function'!$C$5)","v":150}]
[null,"David"]
[null,"John",null,null,null,null,null,"Practice Sheet"]
[]
[null,null,null,null,null,null,null,"Student Class",9]
[]
[null,null,null,null,null,null,null,"Student","Total Mark"]
[null,null,null,null,null,null,null,"Roben"]
[null,null,null,null,null,null,null,"David"]
[null,null,null,null,null,null,null,"John"]

{"sheet":"Sumproduct function","index":4,"n_rows":17,"n_cols":16,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,1,2,4],[9,12,9,15]]}
[]
[]
[null,"Student Number Sheet"]
[]
[null," Class",9]
[]
[null,"Student","Total Mark",null,"Term"]
[null,"Roben",{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(\"'\"&E$8:$E$9&\"'!$D$6:$D$10\"),\nINDIRECT(\"'\"&$E$8:$E$9&\"'!$B$6:$B$10\"),B8,\nINDIRECT(\"'\"&$E$8:$E$9&\"'!$C$6:$C$10\"),$C$5))","v":150},null,"Half yearly"]
[null,"David",{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(\"'\"&E$8:$E$9&\"'!$D$6:$D$10\"),\nINDIRECT(\"'\"&$E$8:$E$9&\"'!$B$6:$B$10\"),B9,\nINDIRECT(\"'\"&$E$8:$E$9&\"'!$C$6:$C$10\"),$C$5))","v":152},null,"Yearly"]
[null,"John",{"$f":"SUMPRODUCT(SUMIFS(INDIRECT(\"'\"&E$8:$E$9&\"'!$D$6:$D$10\"),\nINDIRECT(\"'\"&$E$8:$E$9&\"'!$B$6:$B$10\"),B10,\nINDIRECT(\"'\"&$E$8:$E$9&\"'!$C$6:$C$10\"),$C$5))","v":145},null,null,null,null,null,null,null,null,null,"Practice Sheet"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Student class",9]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Student","Total Mark",null,"Term"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Roben",null,null,"Half yearly"]
[null,null,null,null,null,null,null,null,null,null,null,null,"David",null,null,"Yearly"]
[null,null,null,null,null,null,null,null,null,null,null,null,"John"]

{"sheet":"Sumif diff column","index":5,"n_rows":17,"n_cols":17,"rows_kept":17,"cut":false,"hidden":true,"merged":[[2,1,2,4],[6,13,6,16]]}
[]
[]
[null,"Using SUMIF Function for Multiple Criteria in Different Column"]
[]
[null,"Name","Student Class","Half Yearly Mark","Yearly Mark"]
[null,"Roben",9,80,70]
[null,"James",10,85,60,null,null,null,null,null,null,null,null,"Practice Sheet"]
[null,"David",9,72,80]
[null,"John",9,65,80,null,null,"   ",null,null,null,null,null,"Name","Student Class","Half yearly Mark","Yearly Mark"]
[null,"Simon",10,90,70,null,null,null,null,null,null,null,null,"Roben",9,80,70]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"James",10,85,60]
[null,"Name","Roben",null,null,null,null,null,null,null,null,null,null,"David",9,72,80]
[null,"Total mark",{"$f":"SUMIF(B6:B10,C12,D6:D10)+SUMIF(B6:B10,C12,E6:E10)","v":150},null,null,null,null,null,null,null,null,null,null,"John",9,65,80]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Simon",10,90,70]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Name","Roben"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Total mark"]

{"sheet":"Sumif vlookup","index":6,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":true,"merged":[[2,1,2,2],[8,9,8,10],[6,9,6,10]]}
[]
[]
[null,"Use SUMIF and VLOOKUP Functions for Multiple Sheet"]
[]
[null,"Name","Student Class"]
[null,"Roben",9]
[null,"James",10,null,null,null,null,null,null,"Practice Sheet"]
[null,"David",9]
[null,"John",9,null,null,null,null,null,null,"Sumif Vlookup Multiple Sheet"]
[null,"Simon",10]
[null,null,null,null,null,null,null,null,null,"Name","Student Class"]
[null,"Name","Roben",null,null,null,null,null,null,"Roben",9]
[null,"Total number",{"$f":"SUMIF('Half yearly'!B6:B10,VLOOKUP(C12,B6:B10,1,FALSE),'Half yearly'!D6:D10)\n+SUMIF(Yearly!B6:B10,VLOOKUP(C12,B6:B10,1,FALSE),Yearly!D6:D10)","v":150},null,null,null,null,null,null,"James",10]
[null,null,null,null,null,null,null,null,null,"David",9]
[null,null,null,null,null,null,null,null,null,"John",9]
[null,null,null,null,null,null,null,null,null,"Simon",10]
[]
[null,null,null,null,null,null,null,null,null,"Name","Roben"]
[null,null,null,null,null,null,null,null,null,"Total number"]