{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","SUMIF","GET.CELL","AutoFilter","VBA","COUNTIF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Sales Report"]
[]
[null,"Sales Rep","Product Name","Status","Sales"]
[null,"Jonas","Apple","Delivered",6200]
[null,"Harry","Orange","Delivered",11744]
[null,"Nick","Guava","Not Delivered",5060]
[null,"Sara","Coconut","Delivered",22500]
[null,"John","Apricot","Not Delivered",9075]
[null,"Leon","Watermelon","Not Delivered",17850]
[null,"Tom","Jackfruit","Not Delivered",14040]
[null,"Hardy","Kiwi","Delivered",12150]
[null,"Mark","Lemon","Not Delivered",11400]
[null,"Chris","Avocado","Delivered",10250]

{"sheet":"SUMIF","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,9]]}
[]
[null,"Using SUMIF Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Product Name","Status","Sales","Color",null,null,"Cell Color"]
[null,"Jonas","Apple","Delivered",6200,"White",null,null,"Total Sales"]
[null,"Harry","Orange","Delivered",11744,"White"]
[null,"Nick","Guava","Not Delivered",5060,"Red"]
[null,"Sara","Coconut","Delivered",22500,"White"]
[null,"John","Apricot","Not Delivered",9075,"Red"]
[null,"Leon","Watermelon","Not Delivered",17850,"Red"]
[null,"Tom","Jackfruit","Not Delivered",14040,"Red"]
[null,"Hardy","Kiwi","Delivered",12150,"White"]
[null,"Mark","Lemon","Not Delivered",11400,"Red"]
[null,"Chris","Avocado","Delivered",10250,"White"]
[]
[null,"Cell Color"]
[null,"Total Sales",{"$f":"SUMIF(F5:F14,\"Red\",E5:E14)","v":57425}]

{"sheet":"GET.CELL","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,9]]}
[]
[null,"Employing GET.CELL Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Product Name","Status","Sales","Color Code",null,null,"Cell Color"]
[null,"Jonas","Apple","Delivered",6200,{"$f":"SumRed","v":0},null,null,"Total Sales"]
[null,"Harry","Orange","Delivered",11744,{"$f":"SumRed","v":0}]
[null,"Nick","Guava","Not Delivered",5060,{"$f":"SumRed","v":3}]
[null,"Sara","Coconut","Delivered",22500,{"$f":"SumRed","v":0}]
[null,"John","Apricot","Not Delivered",9075,{"$f":"SumRed","v":3}]
[null,"Leon","Watermelon","Not Delivered",17850,{"$f":"SumRed","v":3}]
[null,"Tom","Jackfruit","Not Delivered",14040,{"$f":"SumRed","v":3}]
[null,"Hardy","Kiwi","Delivered",12150,{"$f":"SumRed","v":0}]
[null,"Mark","Lemon","Not Delivered",11400,{"$f":"SumRed","v":3}]
[null,"Chris","Avocado","Delivered",10250,{"$f":"SumRed","v":0}]
[]
[null,"Cell Color"]
[null,"Total Sales",{"$f":"SUMIF(F5:F14,3,E5:E14)","v":57425}]

{"sheet":"AutoFilter","index":3,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,4],[15,7,15,8]]}
[]
[null,"Utilizing AutoFilter and SUBTOTAL Function"]
[]
[null,"Sales Rep","Product Name","Status","Sales"]
[null,"Jonas","Apple","Delivered",6200]
[null,"Harry","Orange","Delivered",11744]
[null,"Nick","Guava","Not Delivered",5060]
[null,"Sara","Coconut","Delivered",22500]
[null,"John","Apricot","Not Delivered",9075]
[null,"Leon","Watermelon","Not Delivered",17850]
[null,"Tom","Jackfruit","Not Delivered",14040]
[null,"Hardy","Kiwi","Delivered",12150]
[null,"Mark","Lemon","Not Delivered",11400]
[null,"Chris","Avocado","Delivered",10250]
[]
[null,"Cell Color",null,null,null,null,null,"Do It Yourself"]
[null,"Total Sales",{"$f":"SUBTOTAL(109,E5:E14)","v":57425}]
[null,null,null,null,null,null,null,"Cell Color"]
[null,null,null,null,null,null,null,"Total Sales"]

{"sheet":"VBA","index":4,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,7,1,8]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Product Name","Status","Sales",null,null,"Cell Color"]
[null,"Jonas","Apple","Delivered",6200,null,null,"Total Sales"]
[null,"Harry","Orange","Delivered",11744]
[null,"Nick","Guava","Not Delivered",5060]
[null,"Sara","Coconut","Delivered",22500]
[null,"John","Apricot","Not Delivered",9075]
[null,"Leon","Watermelon","Not Delivered",17850]
[null,"Tom","Jackfruit","Not Delivered",14040]
[null,"Hardy","Kiwi","Delivered",12150]
[null,"Mark","Lemon","Not Delivered",11400]
[null,"Chris","Avocado","Delivered",10250]
[]
[null,"Cell Color"]
[null,"Total Sales",{"$f":"Sum_Red_Cells($C$16,E5:E14)","v":57425}]

{"sheet":"COUNTIF","index":5,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,9]]}
[]
[null,"Implementing COUNTIF Function",null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Sales Rep","Product Name","Status","Sales","Color Code",null,null,"Cell Color"]
[null,"Jonas","Apple","Delivered",6200,{"$f":"SumRed","v":0},null,null,"Total Count"]
[null,"Harry","Orange","Delivered",11744,{"$f":"SumRed","v":0}]
[null,"Nick","Guava","Not Delivered",5060,{"$f":"SumRed","v":3}]
[null,"Sara","Coconut","Delivered",22500,{"$f":"SumRed","v":0}]
[null,"John","Apricot","Not Delivered",9075,{"$f":"SumRed","v":3}]
[null,"Leon","Watermelon","Not Delivered",17850,{"$f":"SumRed","v":3}]
[null,"Tom","Jackfruit","Not Delivered",14040,{"$f":"SumRed","v":3}]
[null,"Hardy","Kiwi","Delivered",12150,{"$f":"SumRed","v":0}]
[null,"Mark","Lemon","Not Delivered",11400,{"$f":"SumRed","v":3}]
[null,"Chris","Avocado","Delivered",10250,{"$f":"SumRed","v":0}]
[]
[null,"Cell Color"]
[null,"Total Count",{"$f":"COUNTIF(F5:F14,SumRed)","v":5}]