{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SUMIF to add positive numbers ","Table to sum positive numbers","Filter to sum positive numbers","VBA to sum positive numbers "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"SUMIF to add positive numbers ","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of SUMIF Function",null,null,null,null,null,"Practise Yourself"]
[]
[null,"Date","Profit/Loss",null,null,null,null,"Date","Profit/Loss"]
[null,"2022-01-01",450,null,null,null,null,"2022-01-01",350]
[null,"2022-01-02",200,null,null,null,null,"2022-01-02",200]
[null,"2022-01-03",-375,null,null,null,null,"2022-01-03",-125]
[null,"2022-01-04",-125,null,null,null,null,"2022-01-04",-200]
[null,"2022-01-05",235,null,null,null,null,"2022-01-05",235]
[null,"SUM",{"$f":"SUMIF(C5:C9,\">0\")","v":885},null,null,null,null,"SUM"]

{"sheet":"Table to sum positive numbers","index":1,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of Table ",null,null,null,"Practise Yourself"]
[]
[null,"Date","Profit/Loss",null,null,"Date","Profit/Loss"]
[null,"2022-01-01",450,null,null,"2022-01-01",350]
[null,"2022-01-02",200,null,null,"2022-01-02",200]
[null,"2022-01-03",-375,null,null,"2022-01-03",-125]
[null,"2022-01-04",-125,null,null,"2022-01-04",-200]
[null,"2022-01-05",235,null,null,"2022-01-05",235]
[null,"Total",{"$f":"SUBTOTAL(109,Table5[Profit/Loss])","v":885}]

{"sheet":"Filter to sum positive numbers","index":2,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of Filter",null,null,null,null,null,null,"Practise Yourself"]
[]
[null,"Date","Profit/Loss",null,null,null,null,null,"Date","Profit/Loss"]
[null,"2022-01-01",450,null,null,null,null,null,"2022-01-01",360]
[null,"2022-01-02",200,null,null,null,null,null,"2022-01-02",125]
[null,"2022-01-03",-375,null,null,null,null,null,"2022-01-03",-375]
[null,"2022-01-04",-125,null,null,null,null,null,"2022-01-04",-125]
[null,"2022-01-05",235,null,null,null,null,null,"2022-01-05",235]
[]
[null,"SUM",{"$f":"SUBTOTAL(9,C5:C10)","v":385},null,null,null,null,null,"SUM"]

{"sheet":"VBA to sum positive numbers ","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Use of VBA",null,null,null,null,null,"Practise Yourself"]
[]
[null,"Date","Profit/Loss",null,null,null,null,"Date","Profit/Loss"]
[null,"2022-01-01",450,null,null,null,null,"2022-01-01",350]
[null,"2022-01-02",200,null,null,null,null,"2022-01-02",200]
[null,"2022-01-03",-375,null,null,null,null,"2022-01-03",-125]
[null,"2022-01-04",-125,null,null,null,null,"2022-01-04",-200]
[null,"2022-01-05",235,null,null,null,null,"2022-01-05",235]
[null,"SUM",885,null,null,null,null,"SUM"]