{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","1. SUMIF","2. Helper Column","3. SUMPRODUCT","4. VBA","Non Blank","5. Zero as Blank"],"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":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Donation Tracker of Save the Poor Charity"]
[]
[null,"Donor Name","Donation Amount"]
[null,"John Smith",100]
[null,"Mary Johnson",50]
[null,"William Davis",200]
[null,"Sarah Brown",75]
[null,"James Lee",300]
[null,"Emily Wilson",25]
[null,"Michael Garcia",150]
[null,"Jennifer Rodriguez",50]
[null,"David Martinez",100]
[null,"Susan Anderson",50]

{"sheet":"1. SUMIF","index":1,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of SUMIF Function to Sum Up Blank Cells",null,null,null,null,"Try Yourself"]
[]
[null,"Donor Name","Donation Amount",null,"Total Anonymous Donation",null,"Donor Name","Donation Amount",null,"Total Anonymous Donation"]
[null,"John Smith",100,null,{"$f":"SUMIF(B5:B14,\"\",C5:C14)","v":550},null,"John Smith",100]
[null,"Mary Johnson",50,null,null,null,"Mary Johnson",50]
[null,"William Davis",200,null,null,null,"William Davis",200]
[null,"Sarah Brown",75,null,null,null,"Sarah Brown",75]
[null,null,300,null,null,null,null,300]
[null,"Emily Wilson",25,null,null,null,"Emily Wilson",25]
[null,null,150,null,null,null,null,150]
[null,"Jennifer Rodriguez",50,null,null,null,"Jennifer Rodriguez",50]
[null,null,100,null,null,null,null,100]
[null,"Susan Anderson",50,null,null,null,"Susan Anderson",50]

{"sheet":"2. Helper Column","index":2,"n_rows":14,"n_cols":14,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,7,1,11]]}
[]
[null,"Use of TRIM Functions & Helper Column to Sum Pseudo Blank Cells",null,null,null,null,null,"Try Yourself"]
[]
[null,"Donor Name","Helper Column","Donation Amount",null,"Total Anonymous Donation",null,"Donor Name","Helper Column","Donation Amount",null,"Total Anonymous Donation"]
[null,"John Smith",{"$f":"TRIM(B5)","v":"John Smith"},100,null,{"$f":"SUMIF(C5:C14,\"\",D5:D14)","v":550},null,"John Smith",null,100]
[null,"Mary Johnson",{"$f":"TRIM(B6)","v":"Mary Johnson"},50,null,null,null,"Mary Johnson",null,50]
[null,"William Davis","William Davis",200,null,null,null,"William Davis",null,200,null,null,null,{"$f":"SUMIF(C5:C14,\"\",D5:D14)","v":550}]
[null,"Sarah Brown","Sarah Brown",75,null,null,null,"Sarah Brown",null,75]
[null,"  ","",300,null,null,null,"  ",null,300]
[null,"Emily Wilson","Emily Wilson",25,null,null,null,"Emily Wilson",null,25]
[null,"  ","",150,null,null,null,"  ",null,150]
[null,"Jennifer Rodriguez","Jennifer Rodriguez",50,null,null,null,"Jennifer Rodriguez",null,50]
[null,null,"",100,null,null,null,null,null,100]
[null,"Susan Anderson","Susan Anderson",50,null,null,null,"Susan Anderson",null,50]

{"sheet":"3. SUMPRODUCT","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of SUMPRODUCT, TRIM & LEN Functions to Sum Pseudo Blank Cells",null,null,null,null,"Try Yourself"]
[]
[null,"Donor Name","Donation Amount",null,"Total Anonymous Donation",null,"Donor Name","Donation Amount",null,"Total Anonymous Donation"]
[null,"John Smith",100,null,{"$f":"SUMPRODUCT(--(LEN(TRIM(B5:B14))=0),C5:C14)","v":550},null,"John Smith",100]
[null,"Mary Johnson",50,null,null,null,"Mary Johnson",50]
[null,"William Davis",200,null,null,null,"William Davis",200]
[null,"Sarah Brown",75,null,null,null,"Sarah Brown",75]
[null,"  ",300,null,null,null,"  ",300]
[null,"Emily Wilson",25,null,null,null,"Emily Wilson",25]
[null,"  ",150,null,null,null,"  ",150]
[null,"Jennifer Rodriguez",50,null,null,null,"Jennifer Rodriguez",50]
[null,null,100,null,null,null,null,100]
[null,"Susan Anderson",50,null,null,null,"Susan Anderson",50]

{"sheet":"4. VBA","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Use of VBA Code to Sum Cells Corresponding to Blank Cells",null,null,null,null,"Try Yourself"]
[]
[null,"Donor Name","Donation Amount",null,"Total Anonymous Donation",null,"Donor Name","Donation Amount",null,"Total Anonymous Donation"]
[null,"John Smith",100,null,550,null,"John Smith",100]
[null,"Mary Johnson",50,null,null,null,"Mary Johnson",50]
[null,"William Davis",200,null,null,null,"William Davis",200]
[null,"Sarah Brown",75,null,null,null,"Sarah Brown",75]
[null,null,300,null,null,null,null,300]
[null,"Emily Wilson",25,null,null,null,"Emily Wilson",25]
[null,null,150,null,null,null,null,150]
[null,"Jennifer Rodriguez",50,null,null,null,"Jennifer Rodriguez",50]
[null,null,100,null,null,null,null,100]
[null,"Susan Anderson",50,null,null,null,"Susan Anderson",50]

{"sheet":"Non Blank","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"SUMIF Non-Blank Cells",null,null,null,null,"Try Yourself"]
[]
[null,"Donor Name","Donation Amount",null,"Total Identified Donation",null,"Donor Name","Donation Amount",null,"Total Identified Donation"]
[null,"John Smith",150,null,{"$f":"SUMIF(B5:B14,\"<>\",C5:C14)","v":600},null,"John Smith",150,null,{"$f":"SUMIF(G5:G14,\"<>\",H5:H14)","v":600}]
[null,"Mary Johnson",50,null,null,null,"Mary Johnson",50]
[null,"William Davis",200,null,null,null,"William Davis",200]
[null,"Sarah Brown",75,null,null,null,"Sarah Brown",75]
[null,null,300,null,null,null,null,300]
[null,"Emily Wilson",25,null,null,null,"Emily Wilson",25]
[null,null,150,null,null,null,null,150]
[null,"Jennifer Rodriguez",50,null,null,null,"Jennifer Rodriguez",50]
[null,null,100,null,null,null,null,100]
[null,"Susan Anderson",50,null,null,null,"Susan Anderson",50]

{"sheet":"5. Zero as Blank","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Displaying Sum Zero as Blank Cells",null,null,null,null,"Try Yourself"]
[]
[null,"Column 1","Column 2","Column 3","Column 4",null,"Column 1","Column 2","Column 3","Column 4"]
[null,12,6,-19,10,null,12,6,-19,10]
[null,15,-16,3,-20,null,15,-16,3,-20]
[null,-20,-17,-3,-3,null,-20,-17,-3,-3]
[null,-1,10,12,-8,null,-1,10,12,-8]
[null,-18,-18,-9,-10,null,-18,-18,-9,-10]
[null,4,0,-7,17,null,4,0,-7,17]
[null,2,19,-8,12,null,2,19,-8,12]
[null,-4,15,10,-11,null,-4,15,10,-11]
[null,10,-2,-17,13,null,10,-2,-17,13]
[null,{"$f":"SUM(B5:B13)","v":0},{"$f":"SUM(C5:C13)","v":-3},-38,0,null,{"$f":"SUM(G5:G13)","v":0},{"$f":"SUM(H5:H13)","v":-3},{"$f":"SUM(I5:I13)","v":-38},{"$f":"SUM(J5:J13)","v":0}]