{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["main","1.r1c1","2.evaluate","3.dynamic","4.formulacell","5.wsFunction","dynamic2"],"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":"main","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"VBA: Sum Range of Cells in Row"]
[]
[null,"Fruit","March Sale","April Sale"]
[null,"Apple",400,{"$f":"SUM($C5:C5)","v":400}]
[null,"Banana",500,{"$f":"SUM($C6:C6)","v":500}]
[null,"Guava",600,{"$f":"SUM($C7:C7)","v":600}]
[null,"Orange",300,{"$f":"SUM($C8:C8)","v":300}]
[null,"Coconut",250,{"$f":"SUM($C9:C9)","v":250}]
[null,"Watermelon",180,{"$f":"SUM($C10:C10)","v":180}]

{"sheet":"1.r1c1","index":1,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using R1C1 Style Cell Reference",null,null,null,null,null,null,"Practice"]
[]
[null,"Fruit","March Sale","April Sale","Total Sale",null,null,null,"Fruit","March Sale","April Sale","Total Sale"]
[null,"Apple",400,300,700,null,null,null,"Apple",400,300]
[null,"Banana",500,400,900,null,null,null,"Banana",500,400]
[null,"Guava",600,500,1100,null,null,null,"Guava",600,500]
[null,"Orange",300,200,500,null,null,null,"Orange",300,200]
[null,"Coconut",250,400,650,null,null,null,"Coconut",250,400]
[null,"Watermelon",180,450,630,null,null,null,"Watermelon",180,450]

{"sheet":"2.evaluate","index":2,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using Evaluate",null,null,null,null,null,null,"Practice"]
[]
[null,"Fruit","March Sale","April Sale","Total Sale",null,null,null,"Fruit","March Sale","April Sale","Total Sale"]
[null,"Apple",400,300,700,null,null,null,"Apple",400,300]
[null,"Banana",500,400,900,null,null,null,"Banana",500,400]
[null,"Guava",600,500,1100,null,null,null,"Guava",600,500]
[null,"Orange",300,200,500,null,null,null,"Orange",300,200]
[null,"Coconut",250,400,650,null,null,null,"Coconut",250,400]
[null,"Watermelon",180,450,630,null,null,null,"Watermelon",180,450]

{"sheet":"3.dynamic","index":3,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[12,8,12,11],[1,1,1,4]]}
[]
[null,"Dynamic Output Row"]
[]
[null,"Fruit","March Sale","April Sale","Total Sale"]
[null,"Apple",400,300,700]
[null,"Banana",500,400,900]
[null,"Guava",600,500,1100]
[null,"Orange",300,200,500]
[null,"Coconut",250,400,650]
[null,"Watermelon",180,450,630]
[]
[]
[null,null,null,null,null,null,null,null,"Practice"]
[]
[null,null,null,null,null,null,null,null,"Fruit","March Sale","April Sale","Total Sale"]
[null,null,null,null,null,null,null,null,"Apple",400,300]
[null,null,null,null,null,null,null,null,"Banana",500,400]
[null,null,null,null,null,null,null,null,"Guava",600,500]
[null,null,null,null,null,null,null,null,"Orange",300,200]
[null,null,null,null,null,null,null,null,"Coconut",250,400]
[null,null,null,null,null,null,null,null,"Watermelon",180,450]

{"sheet":"4.formulacell","index":4,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Formula Visible in Cell",null,null,null,null,null,"Practice"]
[]
[null,"Fruit","March Sale","April Sale","Total Sale",null,null,"Fruit","March Sale","April Sale","Total Sale"]
[null,"Apple",400,300,{"$f":"SUM(C5:D5)","v":700},null,null,"Apple",400,300]
[null,"Banana",500,400,900,null,null,"Banana",500,400]
[null,"Guava",600,500,1100,null,null,"Guava",600,500]
[null,"Orange",300,200,500,null,null,"Orange",300,200]
[null,"Coconut",250,400,650,null,null,"Coconut",250,400]
[null,"Watermelon",180,450,630,null,null,"Watermelon",180,450]

{"sheet":"5.wsFunction","index":5,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,10]]}
[]
[null,"Applying Worksheet Function",null,null,null,null,null,"Practice"]
[]
[null,"Fruit","March Sale","April Sale","Total Sale",null,null,"Fruit","March Sale","April Sale","Total Sale"]
[null,"Apple",400,300,700,null,null,"Apple",400,300]
[null,"Banana",500,400,900,null,null,"Banana",500,400]
[null,"Guava",600,500,1100,null,null,"Guava",600,500]
[null,"Orange",300,200,500,null,null,"Orange",300,200]
[null,"Coconut",250,400,650,null,null,"Coconut",250,400]
[null,"Watermelon",180,450,630,null,null,"Watermelon",180,450]

{"sheet":"dynamic2","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Dynamic Cell Reference"]
[]
[null,"Fruit","March Sale","April Sale","Total Sale"]
[null,"Apple",400,300,{"$f":"SUM($C5:D5)","v":700}]
[null,"Banana",500,400,{"$f":"SUM($C6:D6)","v":900}]
[null,"Guava",600,500,{"$f":"SUM($C7:D7)","v":1100}]
[null,"Orange",300,200,{"$f":"SUM($C8:D8)","v":500}]
[null,"Coconut",250,400,{"$f":"SUM($C9:D9)","v":650}]
[null,"Watermelon",180,450,{"$f":"SUM($C10:D10)","v":630}]