{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Question","Try","MrExcel","excelisfun","MrExcel2","Sheet5"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":2},"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":"Question","index":0,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Categories","Total",null,"Data"]
["TBS",null,null,"2871TBS"]
["DDW",null,null,"2020TBS"]
["LQA",null,null,"2127TBS"]
[null,null,null,"2909TBS"]
[null,null,null,2540]
["Question:",null,null,"2976TBS"]
["how to get totals?",null,null,"2140DDW"]
[null,null,null,"2819TBS"]
[null,null,null,3188]
[null,null,null,"1152TBS"]
[null,null,null,"2440LQA"]
[null,null,null,3246]
[null,null,null,"3176LQA"]
[null,null,null,"1301DDW"]

{"sheet":"Try","index":1,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Categories","Total",null,"Data"]
["TBS",null,null,2871]
["DDW",null,null,2020]
["LQA",null,null,2127]
[null,null,null,2909]
[null,null,null,2540]
["Question:",null,null,2976]
["how to get totals?",null,null,2140]
[null,null,null,2819]
[null,null,null,3188]
[null,null,null,1152]
[null,null,null,2440]
[null,null,null,3246]
[null,null,null,3176]
[null,null,null,1301]

{"sheet":"MrExcel","index":2,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Categories","Total",null,"Data","Cat",null,"Row Labels","Sum of Data"]
["TBS",null,null,2871,"TBS",null,"DDW",3441]
["DDW",null,null,2020,"TBS",null,"LQA",5616]
["LQA",null,null,2127,"TBS",null,"TBS",16874]
[null,null,null,2909,"TBS",null,"(blank)",8974]
[null,null,null,2540,null,null,"Grand Total",34905]
["Question:",null,null,2976,"TBS"]
["how to get totals?",null,null,2140,"DDW"]
[{"$f":"LEN(A8)","v":18},null,null,2819,"TBS"]
[null,null,null,3188]
[null,null,null,1152,"TBS"]
[null,null,null,2440,"LQA"]
[null,null,null,3246]
[null,null,null,3176,"LQA"]
[null,null,null,1301,"DDW"]

{"sheet":"excelisfun","index":3,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Categories","Total",null,"Data","Helper",null,"Bill Szysz from YouTube:"]
["TBS",{"$f":"SUMIF($D$2:$D$15,IF(A2=0,\">0\",\"*\"&A2),$E$2:$E$15)","v":16874},null,"2871TBS",{"$f":"LEFT(D2,4)+0","v":2871},null,"Categories","Total",null,null,null,{"$f":"B2=GETPIVOTDATA(\"Data\",MrExcel!$G$1,\"Cat\",\"TBS\")","v":true}]
["DDW",{"$f":"SUMIF($D$2:$D$15,IF(A3=0,\">0\",\"*\"&A3),$E$2:$E$15)","v":3441},null,"2020TBS",{"$f":"LEFT(D3,4)+0","v":2020},null,"TBS",{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,3)=G3)*LEFT($D$2:$D$15,4))","v":16874},null,null,null,{"$f":"GETPIVOTDATA(\"Data\",MrExcel!$G$1,\"Cat\",\"DDW\")=B3","v":true}]
["LQA",5616,null,"2127TBS",2127,null,"DDW",{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,3)=G4)*LEFT($D$2:$D$15,4))","v":3441},null,null,null,{"$f":"GETPIVOTDATA(\"Data\",MrExcel!$G$1,\"Cat\",\"LQA\")=B4","v":true}]
[null,8974,null,"2909TBS",2909,null,"LQA",5616,null,null,null,{"$f":"B5=GETPIVOTDATA(\"Data\",MrExcel!$G$1,\"Cat\",)","v":true}]
[null,null,null,2540,2540,null,null,{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,3)=G6)*LEFT($D$2:$D$15,4))","v":8974}]
["Question:",null,null,"2976TBS",2976]
["how to get totals?",null,null,"2140DDW",2140]
[null,null,null,"2819TBS",2819,null,"Mr Excel & excelisfun Trick 154: Totals by Product Code: Numbers & Code in Same Cell!? "]
["Categories","Total",null,3188,3188]
["TBS",{"$f":"SUMPRODUCT(LEFT($D$2:$D$15,4)+0,--ISNUMBER(SEARCH(A11,$D$2:$D$15)))-(A11=0)*SUM($B$10:B10)","v":16874},{"$f":"-(A11=0)*SUM($B$10:B10)","v":0},"1152TBS",1152]
["DDW",{"$f":"SUMPRODUCT(LEFT($D$2:$D$15,4)+0,--ISNUMBER(SEARCH(A12,$D$2:$D$15)))-(A12=0)*SUM($B$10:B11)","v":3441},{"$f":"-(A12=0)*SUM($B$10:B11)","v":0},"2440LQA",2440]
["LQA",{"$f":"SUMPRODUCT(LEFT($D$2:$D$15,4)+0,--ISNUMBER(SEARCH(A13,$D$2:$D$15)))-(A13=0)*SUM($B$10:B12)","v":5616},{"$f":"-(A13=0)*SUM($B$10:B12)","v":0},3246,3246]
[null,{"$f":"SUMPRODUCT(LEFT($D$2:$D$15,4)+0,--ISNUMBER(SEARCH(A14,$D$2:$D$15)))-(A14=0)*SUM($B$10:B13)","v":8974},{"$f":"-(A14=0)*SUM($B$10:B13)","v":-25931},"3176LQA",3176]
[null,null,null,"1301DDW",1301]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Bob Umlas:",{"$f":"SUMPRODUCT(N(RIGHT($D$2:$D$15,3)=A2),LEFT($D$2:$D$15,4)*1)+IF(A2=0,SUM($D$2:$D$15))","v":16874}]
[null,{"$f":"SUMPRODUCT(N(RIGHT($D$2:$D$15,3)=A3),LEFT($D$2:$D$15,4)*1)+IF(A3=0,SUM($D$2:$D$15))","v":3441}]
[null,{"$f":"SUMPRODUCT(N(RIGHT($D$2:$D$15,3)=A4),LEFT($D$2:$D$15,4)*1)+IF(A4=0,SUM($D$2:$D$15))","v":5616}]
[null,{"$f":"SUMPRODUCT(N(RIGHT($D$2:$D$15,3)=A5),LEFT($D$2:$D$15,4)*1)+IF(A5=0,SUM($D$2:$D$15))","v":8974}]
[]
["Bill Szysz:",{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,10)=A2)*LEFT($D$2:$D$15,4))","v":16874}]
[null,{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,10)=A3)*LEFT($D$2:$D$15,4))","v":3441}]
[null,{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,10)=A4)*LEFT($D$2:$D$15,4))","v":5616}]
[null,{"$f":"SUMPRODUCT((MID($D$2:$D$15,5,10)=A5)*LEFT($D$2:$D$15,4))","v":8974}]

{"sheet":"MrExcel2","index":4,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Categories","Total",null,"Data"]
["TBS",{"$f":"sumtext($D$2:$D$15,A2)","v":16874},null,"2871TBS"]
["DDW",{"$f":"sumtext($D$2:$D$15,A3)","v":3441},null,"2020TBS"]
["LQA",5616,null,"2127TBS"]
[null,8974,null,"2909TBS"]
[null,null,null,2540]
["Question:",null,null,"2976TBS"]
["how to get totals?",null,null,"2140DDW"]
[null,null,null,"2819TBS"]
[null,null,null,3188]
[null,null,null,"1152TBS"]
[null,null,null,"2440LQA"]
[null,null,null,3246]
[null,null,null,"3176LQA"]
[null,null,null,"1301DDW"]

{"sheet":"Sheet5","index":5,"n_rows":17,"n_cols":22,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Data","Helper",null,"Categories","Total",null,null,null,"Data","TTC1","TTC2",null,null,null,null,null,null,null,null,null,null," =RANDBETWEEN(100,340)&CHOOSE(RANDBETWEEN(1,4),\"DDW\",\"TBS\",\"LQA\",0)"]
["2871TBS",{"$f":"LEFT(A2,4)+0","v":2871},null,"TBS",{"$f":"SUMPRODUCT(LEFT($A$2:$A$15,4)+0,--ISNUMBER(SEARCH(D2,$A$2:$A$15)))-(D2=0)*SUM($E$1:E1)","v":16874},null,{"$f":"A2<9.9E+307","v":false},null,"2871TBS",2871,"TBS"]
["2020TBS",{"$f":"LEFT(A3,4)+0","v":2020},null,"DDW",{"$f":"SUMPRODUCT(LEFT($A$2:$A$15,4)+0,--ISNUMBER(SEARCH(D3,$A$2:$A$15)))-(D3=0)*SUM($E$1:E2)","v":3441},null,false,null,"2020TBS",2020,"TBS"]
["2127TBS",2127,null,"LQA",{"$f":"SUMPRODUCT(LEFT($A$2:$A$15,4)+0,--ISNUMBER(SEARCH(D4,$A$2:$A$15)))-(D4=0)*SUM($E$1:E3)","v":5616},null,false,null,"2127TBS",2127,"TBS",null,"Categories","Total"]
["2909TBS",2909,null,null,{"$f":"SUMPRODUCT(LEFT($A$2:$A$15,4)+0,--ISNUMBER(SEARCH(D5,$A$2:$A$15)))-(D5=0)*SUM($E$1:E4)","v":8974},null,false,null,"2909TBS",2909,"TBS",null,"TBS",{"$f":"SUMIF($K$2:$K$15,M5,$J$2:$J$15)","v":16874}]
[2540,2540,null,null,null,null,true,null,2540,2540,null,null,"DDW",{"$f":"SUMIF($K$2:$K$15,M6,$J$2:$J$15)","v":3441}]
["2976TBS",2976,null,null,null,null,false,null,"2976TBS",2976,"TBS",null,"LQA",{"$f":"SUMIF($K$2:$K$15,M7,$J$2:$J$15)","v":5616}]
["2140DDW",2140,null,"Categories","Total",null,false,null,"2140DDW",2140,"DDW",null,{"$f":"\"\"","v":""},{"$f":"SUMIF($K$2:$K$15,M8,$J$2:$J$15)","v":8974}]
["2819TBS",2819,null,"TBS",{"$f":"SUMIFS($B$2:$B$15,$A$2:$A$15,IF(D9=0,\">0\",\"*\"&D9))","v":16874},null,false,null,"2819TBS",2819,"TBS"]
[3188,3188,null,"DDW",{"$f":"SUMIFS($B$2:$B$15,$A$2:$A$15,IF(D10=0,\">0\",\"*\"&D10))","v":3441},null,true,null,3188,3188,null,null,"Row Labels","Sum of TTC1"]
["1152TBS",1152,null,"LQA",5616,null,false,null,"1152TBS",1152,"TBS",null,"DDW",3441]
["2440LQA",2440,null,null,8974,null,false,null,"2440LQA",2440,"LQA",null,"LQA",5616]
[3246,3246,null,null,null,null,true,null,3246,3246,null,null,"TBS",16874]
["3176LQA",3176,null,null,null,null,false,null,"3176LQA",3176,"LQA",null,"(blank)",8974]
["1301DDW",1301,null,null,null,null,false,null,"1301DDW",1301,"DDW",null,"Grand Total",34905]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM({2871;2020;2127;2909;2540;2976;2140;2819;3188;1152;2440;3246;3176;1301})","v":34905}]