{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Practice","SUMIF(text)1.1","SUM,IF,ISTEXT 1.2","Cell Number 1.3","Partial match SUMIF 1.4","Case sensitive SUMPRODUCT 1.5","SUMIFS(text) 1.6","SUMIF(number)2.1","both Text and Number(3) ","VBA","Sheet8"],"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":"Practice","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"SUMIF(text)1.1","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Amount of the Products Customer Having Text Address"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,{"$f":"SUMIF(D5:D11,\"*\",F5:F11)","v":1720}]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"SUM,IF,ISTEXT 1.2","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Amount of the Products Customer Having Text Address"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,{"$f":"SUM(IF(ISTEXT(D5:D11),F5:F11,0))","v":1720}]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"Cell Number 1.3","index":3,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8],[7,7,7,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Sales of Laptop"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,"Laptop"]
[null,"2023-01-21","Dockrell",3055554321,"PC",770,null,{"$f":"SUMIF(E5:E11,\"*\"& H7 &\"*\",F5:F11)","v":2020}]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"Partial match SUMIF 1.4","index":4,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Amount of PC"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,{"$f":"SUMIF(E5:E11,\"*pc\",F5:F11)","v":2200}]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"Case sensitive SUMPRODUCT 1.5","index":5,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Sales of Pc(Case-Sensitive)"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,{"$f":"SUMPRODUCT(ISNUMBER(FIND(\"Pc\",E5:E11))*F5:F11)","v":1430}]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"Pc",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"SUMIFS(text) 1.6","index":6,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Amount of the Products Customer Having Text Address"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,{"$f":"SUMIFS(F5:F11,D5:D11,\"*\")","v":1720}]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"SUMIF(number)2.1","index":7,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8],[6,7,6,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Amount",null,"Total Amount of the Products Customer Having Number Address"]
[null,"2023-01-12","Alan",41555587,"Laptop",900]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4",550]
[null,"2023-01-17","George","hkd@gmail.com","Laptop",1120,null,{"$f":"SUM(IF(ISNUMBER(D5:D11),F5:F11,0))","v":3190}]
[null,"2023-01-21","Dockrell",3055554321,"PC",770]
[null,"2023-01-22","David",2123755589,"PC",1430]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD",50]
[null,"2023-01-30","Sara",8185559876,"SDD",90]

{"sheet":"both Text and Number(3) ","index":8,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,7,5,8]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Product","Storage",null,"Total Storage Capacity"]
[null,"2023-01-12","Alan",41555587,"Laptop","1 TB"]
[null,"2023-01-15","Smith","smithasd@yahoo.com","PS4","500 GB"]
[null,"2023-01-17","George","hkd@gmail.com","Laptop","256 GB",null,"GB",{"$f":"SUM(IF(ISNUMBER(FIND(H7,$F$5:$F$11)),VALUE(LEFT($F$5:$F$11,FIND(H7,$F$5:$F$11)-1)),0))","v":1684}]
[null,"2023-01-21","Dockrell",3055554321,"PC","800 GB",null,"TB",{"$f":"SUM(IF(ISNUMBER(FIND(H8,$F$5:$F$11)),VALUE(LEFT($F$5:$F$11,FIND(H8,$F$5:$F$11)-1)),0))","v":8}]
[null,"2023-01-22","David",2123755589,"PC","2 TB"]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","HDD","5 TB"]
[null,"2023-01-30","Sara",8185559876,"SDD","128 GB"]

{"sheet":"VBA","index":9,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Sales Record of Continental Group"]
[]
[null,"Date","Customer Name","Customer Address","Purchased Products","Total Product"]
[null,"2023-01-12","Alan",41555587,"1 Laptop, 2 HDD",{"$f":"SumNumbers(E5)","v":3}]
[null,"2023-01-15","Smith","smithasd@yahoo.com","3 Play Station, 1CD",{"$f":"SumNumbers(E6)","v":4}]
[null,"2023-01-17","George","hkd@gmail.com","5 Laptop, 1 SSD",{"$f":"SumNumbers(E7)","v":6}]
[null,"2023-01-21","Dockrell",3055554321,"1 PC, 1 Router",{"$f":"SumNumbers(E8)","v":2}]
[null,"2023-01-22","David",2123755589,"3 PC",{"$f":"SumNumbers(E9)","v":3}]
[null,"2023-01-23","Jenny","janebsd@hotmail.com","8 HDD, 12 SSD",{"$f":"SumNumbers(E10)","v":20}]
[null,"2023-01-30","Sara",8185559876,"5 SDD, 1 Memory Card",{"$f":"SumNumbers(E11)","v":6}]

{"sheet":"Sheet8","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}