{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Dataset","Subtotal","Subtotal Button","Subtotal Selected"],"not_rendered":{"charts":0,"images":2,"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":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Calculating Subtotal with VBA"]
[]
[null,"Product ID","Product Name","Quantity","Price per Piece","Sales in January","Sales in February","Sales in March"]
[null,101,"Cricket Ball",100,50,{"$f":"30*$E5","v":1500},{"$f":"50*$E5","v":2500},{"$f":"20*$E5","v":1000}]
[null,102,"Cricket Ball",150,100,{"$f":"50*$E6","v":5000},{"$f":"70*$E6","v":7000},{"$f":"30*$E6","v":3000}]
[null,103,"Cricket Ball",200,80,{"$f":"30*$E7","v":2400},{"$f":"100*$E7","v":8000},{"$f":"50*$E7","v":4000}]
[null,104,"Football",350,35,{"$f":"200*$E8","v":7000},{"$f":"100*$E8","v":3500},{"$f":"50*$E8","v":1750}]
[null,105,"Football",250,40,{"$f":"20*$E9","v":800},{"$f":"30*$E9","v":1200},{"$f":"90*$E9","v":3600}]
[null,106,"Football",300,75,{"$f":"180*$E10","v":13500},{"$f":"80*$E10","v":6000},{"$f":"40*$E10","v":3000}]
[null,107,"Football",550,60,{"$f":"300*$E11","v":18000},{"$f":"200*$E11","v":12000},{"$f":"30*$E11","v":1800}]
[null,108,"Tennis Ball",50,10,{"$f":"40*$E12","v":400},{"$f":"8*$E12","v":80},{"$f":"2*$E12","v":20}]
[null,109,"Tennis Ball",400,15,{"$f":"145*$E13","v":2175},{"$f":"210*$E13","v":3150},{"$f":"25*$E13","v":375}]
[null,110,"Tennis Ball",450,8,{"$f":"35*$E14","v":280},{"$f":"60*$E14","v":480},{"$f":"40*$E14","v":320}]

{"sheet":"Subtotal","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Calculating Subtotal with VBA"]
[]
[null,"Product ID","Product Name","Quantity","Price per Piece","Sales in January","Sales in February","Sales in March"]
[null,101,"Cricket Ball",100,50,{"$f":"30*$E5","v":1500},{"$f":"50*$E5","v":2500},{"$f":"20*$E5","v":1000}]
[null,102,"Cricket Ball",150,100,{"$f":"50*$E6","v":5000},{"$f":"70*$E6","v":7000},{"$f":"30*$E6","v":3000}]
[null,103,"Cricket Ball",200,80,{"$f":"30*$E7","v":2400},{"$f":"100*$E7","v":8000},{"$f":"50*$E7","v":4000}]
[null,null,"Subtotal Cricket Ball",null,null,{"$f":"SUM(F$5:F$7)","v":8900},{"$f":"SUM(G$5:G$7)","v":17500},{"$f":"SUM(H$5:H$7)","v":8000}]
[null,104,"Football",350,35,{"$f":"200*$E9","v":7000},{"$f":"100*$E9","v":3500},{"$f":"50*$E9","v":1750}]
[null,105,"Football",250,40,{"$f":"20*$E10","v":800},{"$f":"30*$E10","v":1200},{"$f":"90*$E10","v":3600}]
[null,106,"Football",300,75,{"$f":"180*$E11","v":13500},{"$f":"80*$E11","v":6000},{"$f":"40*$E11","v":3000}]
[null,107,"Football",550,60,{"$f":"300*$E12","v":18000},{"$f":"200*$E12","v":12000},{"$f":"30*$E12","v":1800}]
[null,null,"Subtotal Football",null,null,{"$f":"SUM(F$9:F$12)","v":39300},{"$f":"SUM(G$9:G$12)","v":22700},{"$f":"SUM(H$9:H$12)","v":10150}]
[null,108,"Tennis Ball",50,10,{"$f":"40*$E14","v":400},{"$f":"8*$E14","v":80},{"$f":"2*$E14","v":20}]
[null,109,"Tennis Ball",400,15,{"$f":"145*$E15","v":2175},{"$f":"210*$E15","v":3150},{"$f":"25*$E15","v":375}]
[null,110,"Tennis Ball",450,8,{"$f":"35*$E16","v":280},{"$f":"60*$E16","v":480},{"$f":"40*$E16","v":320}]
[null,null,"Subtotal Tennis Ball",null,null,{"$f":"SUM(F$14:F$16)","v":2855},{"$f":"SUM(G$14:G$16)","v":3710},{"$f":"SUM(H$14:H$16)","v":715}]

{"sheet":"Subtotal Button","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Calculating Subtotal with Button in VBA"]
[]
[null,"Product ID","Product Name","Quantity","Price per Piece","January","February","March"]
[null,101,"Cricket Ball",100,50,{"$f":"30*$E5","v":1500},{"$f":"50*$E5","v":2500},{"$f":"20*$E5","v":1000}]
[null,102,"Cricket Ball",150,100,{"$f":"50*$E6","v":5000},{"$f":"70*$E6","v":7000},{"$f":"30*$E6","v":3000}]
[null,103,"Cricket Ball",200,80,{"$f":"30*$E7","v":2400},{"$f":"100*$E7","v":8000},{"$f":"50*$E7","v":4000}]
[null,null,"Cricket Ball Total",null,null,{"$f":"SUBTOTAL(9,F5:F7)","v":8900},{"$f":"SUBTOTAL(9,G5:G7)","v":17500},{"$f":"SUBTOTAL(9,H5:H7)","v":8000}]
[null,104,"Football",350,35,{"$f":"200*$E9","v":7000},{"$f":"100*$E9","v":3500},{"$f":"50*$E9","v":1750}]
[null,105,"Football",250,40,{"$f":"20*$E10","v":800},{"$f":"30*$E10","v":1200},{"$f":"90*$E10","v":3600}]
[null,106,"Football",300,75,{"$f":"180*$E11","v":13500},{"$f":"80*$E11","v":6000},{"$f":"40*$E11","v":3000}]
[null,107,"Football",550,60,{"$f":"300*$E12","v":18000},{"$f":"200*$E12","v":12000},{"$f":"30*$E12","v":1800}]
[null,null,"Football Total",null,null,{"$f":"SUBTOTAL(9,F9:F12)","v":39300},{"$f":"SUBTOTAL(9,G9:G12)","v":22700},{"$f":"SUBTOTAL(9,H9:H12)","v":10150}]
[null,108,"Tennis Ball",50,10,{"$f":"40*$E14","v":400},{"$f":"8*$E14","v":80},{"$f":"2*$E14","v":20}]
[null,109,"Tennis Ball",400,15,{"$f":"145*$E15","v":2175},{"$f":"210*$E15","v":3150},{"$f":"25*$E15","v":375}]
[null,110,"Tennis Ball",450,8,{"$f":"35*$E16","v":280},{"$f":"60*$E16","v":480},{"$f":"40*$E16","v":320}]
[null,null,"Tennis Ball Total",null,null,{"$f":"SUBTOTAL(9,F14:F16)","v":2855},{"$f":"SUBTOTAL(9,G14:G16)","v":3710},{"$f":"SUBTOTAL(9,H14:H16)","v":715}]
[null,null,"Grand Total",null,null,{"$f":"SUBTOTAL(9,F5:F16)","v":51055},{"$f":"SUBTOTAL(9,G5:G16)","v":43910},{"$f":"SUBTOTAL(9,H5:H16)","v":18865}]

{"sheet":"Subtotal Selected","index":3,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,7]]}
[]
[null,"Calculating Subtotal for a Specified Range with Button in VBA"]
[]
[null,"Product ID","Product Name","Quantity","Price per Piece","January","February","March"]
[null,101,"Cricket Ball",100,50,{"$f":"30*$E5","v":1500},{"$f":"50*$E5","v":2500},{"$f":"20*$E5","v":1000}]
[null,102,"Cricket Ball",150,100,{"$f":"50*$E6","v":5000},{"$f":"70*$E6","v":7000},{"$f":"30*$E6","v":3000}]
[null,103,"Cricket Ball",200,80,{"$f":"30*$E7","v":2400},{"$f":"100*$E7","v":8000},{"$f":"50*$E7","v":4000}]
[null,null,"Cricket Ball Total",null,null,{"$f":"SUBTOTAL(9,F5:F7)","v":8900},{"$f":"SUBTOTAL(9,G5:G7)","v":17500},{"$f":"SUBTOTAL(9,H5:H7)","v":8000}]
[null,104,"Football",350,35,{"$f":"200*$E9","v":7000},{"$f":"100*$E9","v":3500},{"$f":"50*$E9","v":1750}]
[null,105,"Football",250,40,{"$f":"20*$E10","v":800},{"$f":"30*$E10","v":1200},{"$f":"90*$E10","v":3600}]
[null,106,"Football",300,75,{"$f":"180*$E11","v":13500},{"$f":"80*$E11","v":6000},{"$f":"40*$E11","v":3000}]
[null,107,"Football",550,60,{"$f":"300*$E12","v":18000},{"$f":"200*$E12","v":12000},{"$f":"30*$E12","v":1800}]
[null,null,"Football Total",null,null,{"$f":"SUBTOTAL(9,F9:F12)","v":39300},{"$f":"SUBTOTAL(9,G9:G12)","v":22700},{"$f":"SUBTOTAL(9,H9:H12)","v":10150}]
[null,null,"Grand Total",null,null,{"$f":"SUBTOTAL(9,F5:F12)","v":48200},{"$f":"SUBTOTAL(9,G5:G12)","v":40200},{"$f":"SUBTOTAL(9,H5:H12)","v":18150}]
[null,108,"Tennis Ball",50,10,{"$f":"40*$E15","v":400},{"$f":"8*$E15","v":80},{"$f":"2*$E15","v":20}]
[null,109,"Tennis Ball",400,15,{"$f":"145*$E16","v":2175},{"$f":"210*$E16","v":3150},{"$f":"25*$E16","v":375}]
[null,110,"Tennis Ball",450,8,{"$f":"35*$E17","v":280},{"$f":"60*$E17","v":480},{"$f":"40*$E17","v":320}]