{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","SUM,LEFT,FIND","SUMPRODUCT","TRIM,IFERROR","SUM,IFERROR,RIGHT","Categories","VBA"],"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":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Summing Only Numbers Ignore Text"]
[]
[null,"Name & Salary",null,"Total"]
[null,"1400 Harry"]
[null,"1350 Ron"]
[null,"1600 Hermoine"]
[null,"1380 Malfoy"]
[null,"1250 Hagrid"]
[null,"1800 Albus"]
[null,"1500 Hondo"]
[null,"1800 Sonny"]
[null,"2000 Vito"]
[null,"1750 Vitoria"]

{"sheet":"SUM,LEFT,FIND","index":1,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using SUM, LEFT & FIND Functions"]
[]
[null,"Name & Salary",null,"Total"]
[null,"1400 Harry",null,{"$f":"SUM(--LEFT(B5:B14,FIND(\" \",B5:B14)))","v":15830}]
[null,"1350 Ron"]
[null,"1600 Hermoine"]
[null,"1380 Malfoy"]
[null,"1250 Hagrid"]
[null,"1800 Albus"]
[null,"1500 Hondo"]
[null,"1800 Sonny"]
[null,"2000 Vito"]
[null,"1750 Vitoria"]

{"sheet":"SUMPRODUCT","index":2,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing SUMPRODUCT, LEFT & FIND Functions"]
[]
[null,"Name & Salary",null,"Total"]
[null,"1400 Harry",null,{"$f":"SUMPRODUCT(--LEFT(B5:B14,FIND(\" \",B5:B14)))","v":15830}]
[null,"1350 Ron"]
[null,"1600 Hermoine"]
[null,"1380 Malfoy"]
[null,"1250 Hagrid"]
[null,"1800 Albus"]
[null,"1500 Hondo"]
[null,"1800 Sonny"]
[null,"2000 Vito"]
[null,"1750 Vitoria"]

{"sheet":"TRIM,IFERROR","index":3,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying TRIM & IFERROR Functions"]
[]
[null,"Name & Salary",null,"Total"]
[null,"1400 Harry",null,{"$f":"SUM(--TRIM(IFERROR(LEFT(B5:B14,FIND(\" \",B5:B14)),0)))","v":15830}]
[null,"1350 Ron"]
[null,"1600 Hermoine"]
[null,"1380 Malfoy"]
[null,"1250 Hagrid"]
[null,"1800 Albus"]
[null,"1500 Hondo"]
[null,"1800 Sonny"]
[null,"2000 Vito"]
[null,"1750 Vitoria"]

{"sheet":"SUM,IFERROR,RIGHT","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combining SUM, IFERROR & RIGHT Functions"]
[]
[null,"Name & Salary",null,"Total"]
[null,"Harry 1400",null,{"$f":"SUM(IFERROR(--RIGHT(B5:B14,4),0))","v":15830}]
[null,"Ron 1350"]
[null,"Hermoine 1600"]
[null,"Malfoy 1380"]
[null,"Hagrid 1250"]
[null,"Albus 1800"]
[null,"Hondo 1500"]
[null,"Sonny 1800"]
[null,"Vito 2000"]
[null,"Vitoria 1750"]

{"sheet":"Categories","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Summing Only Numbers Based on Categories"]
[]
[null,"Product Name","Price",null,"Price Unit ","Total"]
[null,"Laptop","250 Dollar",null,"Dollar",{"$f":"SUM(IF(ISNUMBER(FIND(E5,$B$5:$C$14)),VALUE(LEFT($C$5:$C$14,FIND(E5,$C$5:$C$14)-1)),0))","v":265}]
[null,"Monitor","110 Euro",null,"Euro",{"$f":"SUM(IF(ISNUMBER(FIND(E6,$B$5:$C$14)),VALUE(LEFT($C$5:$C$14,FIND(E6,$C$5:$C$14)-1)),0))","v":172}]
[null,"Printer","20 Pound",null,"Pound",{"$f":"SUM(IF(ISNUMBER(FIND(E7,$B$5:$C$14)),VALUE(LEFT($C$5:$C$14,FIND(E7,$C$5:$C$14)-1)),0))","v":80}]
[null,"Keyboard","10 Pound"]
[null,"Mouse","5 Dollar"]
[null,"RAM","60 Euro"]
[null,"Desk Lamp","10 Dollar"]
[null,"Pages","2 Euro"]
[null,"Projector","30 Pound"]
[null,"Webcam","20 Pound"]

{"sheet":"VBA","index":6,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Embedding VBA Code"]
[]
[null,"Name & Salary",null,"Total"]
[null,"Harry 1400",null,{"$f":"sum_only_numbers(B5:B14)","v":15830}]
[null,"Ron 1350"]
[null,"Hermoine 1600"]
[null,"Malfoy 1380"]
[null,"Hagrid 1250"]
[null,"Albus 1800"]
[null,"Hondo 1500"]
[null,"Sonny 1800"]
[null,"Vito 2000"]
[null,"Vitoria 1750"]