{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["COUNTIF Function","INDEX and MATCH Functions","LARGE and COLUMN Functions"," VBA Code","OFFSET Function"],"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":"COUNTIF Function","index":0,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[]
[null,"Student Marks"]
[]
[null,"Student Names","Physics ","History","Chemistry ","Math","Biology ","Psychology","English","Total"]
[null,"Antony",60,55,70,60,90,60,70,{"$f":"IF(COUNTIF($C6:$I6,\">0\")>=5,SUM(LARGE(SUBTOTAL(9,OFFSET($C6,0,LARGE(IF($C6:$I6>0,COLUMN($C6:$I6)-COLUMN($C6)+1)-1,{1,2,3,4,5}))),{1,2,3,4,5})),\"< 5 Values\")","v":350}]
[null,"Allison",98,74,90,98,40,98,90,{"$f":"IF(COUNTIF($C7:$I7,\">0\")>=5,SUM(LARGE(SUBTOTAL(9,OFFSET($C7,0,LARGE(IF($C7:$I7>0,COLUMN($C7:$I7)-COLUMN($C7)+1)-1,{1,2,3,4,5}))),{1,2,3,4,5})),\"< 5 Values\")","v":416}]
[null,"Fred",55,46,67,50,80,50,60,{"$f":"IF(COUNTIF($C8:$I8,\">0\")>=5,SUM(LARGE(SUBTOTAL(9,OFFSET($C8,0,LARGE(IF($C8:$I8>0,COLUMN($C8:$I8)-COLUMN($C8)+1)-1,{1,2,3,4,5}))),{1,2,3,4,5})),\"< 5 Values\")","v":307}]
[null,"Lucas",70,71,75,60,90,70,75,{"$f":"IF(COUNTIF($C9:$I9,\">0\")>=5,SUM(LARGE(SUBTOTAL(9,OFFSET($C9,0,LARGE(IF($C9:$I9>0,COLUMN($C9:$I9)-COLUMN($C9)+1)-1,{1,2,3,4,5}))),{1,2,3,4,5})),\"< 5 Values\")","v":370}]
[null,"Pedro",36,38,50,75,60,40,50,{"$f":"IF(COUNTIF($C10:$I10,\">0\")>=5,SUM(LARGE(SUBTOTAL(9,OFFSET($C10,0,LARGE(IF($C10:$I10>0,COLUMN($C10:$I10)-COLUMN($C10)+1)-1,{1,2,3,4,5}))),{1,2,3,4,5})),\"< 5 Values\")","v":275}]
[null,"Vini",80,78,72,50,75,80,80,{"$f":"IF(COUNTIF($C11:$I11,\">0\")>=5,SUM(LARGE(SUBTOTAL(9,OFFSET($C11,0,LARGE(IF($C11:$I11>0,COLUMN($C11:$I11)-COLUMN($C11)+1)-1,{1,2,3,4,5}))),{1,2,3,4,5})),\"< 5 Values\")","v":357}]

{"sheet":"INDEX and MATCH Functions","index":1,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[]
[null,"Student Marks"]
[]
[null,"Student Names","Physics ","History","Chemistry ","Math","Biology ","Psychology","English","Total"]
[null,"Antony",60,55,70,60,90,60,70,{"$f":"SUM(INDEX($C6:$I6,MATCH(9.9E+307,$C6:INDEX($C6:$I6,MATCH(9.9E+307,$C6:$I6)-4))):$I6)","v":350}]
[null,"Allison",98,74,90,98,40,98,90,{"$f":"SUM(INDEX($C7:$I7,MATCH(9.9E+307,$C7:INDEX($C7:$I7,MATCH(9.9E+307,$C7:$I7)-4))):$I7)","v":416}]
[null,"Fred",55,46,67,50,80,50,60,{"$f":"SUM(INDEX($C8:$I8,MATCH(9.9E+307,$C8:INDEX($C8:$I8,MATCH(9.9E+307,$C8:$I8)-4))):$I8)","v":307}]
[null,"Lucas",70,71,75,60,90,70,75,{"$f":"SUM(INDEX($C9:$I9,MATCH(9.9E+307,$C9:INDEX($C9:$I9,MATCH(9.9E+307,$C9:$I9)-4))):$I9)","v":370}]
[null,"Pedro",36,38,50,75,60,40,50,{"$f":"SUM(INDEX($C10:$I10,MATCH(9.9E+307,$C10:INDEX($C10:$I10,MATCH(9.9E+307,$C10:$I10)-4))):$I10)","v":275}]
[null,"Vini",80,78,72,50,75,80,80,{"$f":"SUM(INDEX($C11:$I11,MATCH(9.9E+307,$C11:INDEX($C11:$I11,MATCH(9.9E+307,$C11:$I11)-4))):$I11)","v":357}]

{"sheet":"LARGE and COLUMN Functions","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[]
[null,"Student Marks"]
[]
[null,"Student Names","Physics ","History","Chemistry ","Math","Biology ","Psychology","English","Total"]
[null,"Antony",60,55,70,60,90,60,70,{"$f":"SUM((COLUMN($C6:$I6)>=LARGE(COLUMN($C6:$I6)*(N(+$C6:$I6)>0),5))*N(+$C6:$I6))","v":350}]
[null,"Allison",98,74,90,98,40,98,90,{"$f":"SUM((COLUMN($C7:$I7)>=LARGE(COLUMN($C7:$I7)*(N(+$C7:$I7)>0),5))*N(+$C7:$I7))","v":416}]
[null,"Fred",55,46,67,50,80,50,60,{"$f":"SUM((COLUMN($C8:$I8)>=LARGE(COLUMN($C8:$I8)*(N(+$C8:$I8)>0),5))*N(+$C8:$I8))","v":307}]
[null,"Lucas",70,71,75,60,90,70,75,{"$f":"SUM((COLUMN($C9:$I9)>=LARGE(COLUMN($C9:$I9)*(N(+$C9:$I9)>0),5))*N(+$C9:$I9))","v":370}]
[null,"Pedro",36,38,50,75,60,40,50,{"$f":"SUM((COLUMN($C10:$I10)>=LARGE(COLUMN($C10:$I10)*(N(+$C10:$I10)>0),5))*N(+$C10:$I10))","v":275}]
[null,"Vini",80,78,72,50,75,80,80,{"$f":"SUM((COLUMN($C11:$I11)>=LARGE(COLUMN($C11:$I11)*(N(+$C11:$I11)>0),5))*N(+$C11:$I11))","v":357}]

{"sheet":" VBA Code","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[]
[null,"Student Marks"]
[]
[null,"Student Names","Physics ","History","Chemistry ","Math","Biology ","Psychology","English","Total"]
[null,"Antony",60,55,70,60,90,60,70,{"$f":"sum_last_5_Values_in_Row(C6:I6)","v":350}]
[null,"Allison",98,74,90,98,40,98,90,{"$f":"sum_last_5_Values_in_Row(C7:I7)","v":416}]
[null,"Fred",55,46,67,50,80,50,60,{"$f":"sum_last_5_Values_in_Row(C8:I8)","v":307}]
[null,"Lucas",70,71,75,60,90,70,75,{"$f":"sum_last_5_Values_in_Row(C9:I9)","v":370}]
[null,"Pedro",36,38,50,75,60,40,50,{"$f":"sum_last_5_Values_in_Row(C10:I10)","v":275}]
[null,"Vini",80,78,72,50,75,80,80,{"$f":"sum_last_5_Values_in_Row(C11:I11)","v":357}]

{"sheet":"OFFSET Function","index":4,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,1,2,9]]}
[]
[]
[null,"Student Marks"]
[]
[null,"Student Names","Physics ","History","Chemistry ","Math","Biology ","Psychology","English","Total"]
[null,"Antony",60,55,70,60,90,60,70,{"$f":"SUM(OFFSET($C6,0,COUNT($C6:$I6)-1,,-5))","v":350}]
[null,"Allison",98,74,90,98,40,98,90,{"$f":"SUM(OFFSET($C7,0,COUNT($C7:$I7)-1,,-5))","v":416}]
[null,"Fred",55,46,67,50,80,50,60,307]
[null,"Lucas",70,71,75,60,90,70,75,370]
[null,"Pedro",36,38,50,75,60,40,50,275]
[null,"Vini",80,78,72,50,75,80,80,357]