{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Title","Data","Wrap Up"],"not_rendered":{"charts":0,"images":7,"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":"Title","index":0,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,2220]

{"sheet":"Data","index":1,"n_rows":16,"n_cols":38,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"Q1","Q2","Q3","Total",null,null,null,123,null,123,234,345]
["East",123,234,345,{"$f":"SUM(B2:D2)","v":702},null,null,null,123]
["Central",456,567,678,{"$f":"SUM(B3:D3)","v":1701},null,null,null,123]
["West",891,912,876,{"$f":"SUM(B4:D4)","v":2679}]
["Total",{"$f":"SUM(B2:B4)","v":1470},{"$f":"SUM(C2:C4)","v":1713},{"$f":"SUM(D2:D4)","v":1899},{"$f":"SUM(B5:D5)","v":5082}]
[]
["Total",null,null,null,null,null,null,{"$f":"SUM($H$8:$H$14)","v":1554},null,{"$f":"SUM($J$8:$J$11)","v":888},null,{"$f":"SUM($L$8:$L$16)","v":1998},null,{"$f":"SUM($N$8:$N$16)","v":1998},null,{"$f":"SUM($P$8:$P$16)","v":1998},null,{"$f":"SUM($R$8:$R$16)","v":1998}]
[null,123,null,111,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,234,null,111,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,345,null,111,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,456,null,111,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,567,null,111,null,222,null,222,null,null,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,678,null,111,null,222,null,222,null,null,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,789,null,null,null,222,null,222,null,null,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,900,null,null,null,222,null,null,null,null,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]
[null,1011,null,null,null,222,null,null,null,null,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222,null,222]

{"sheet":"Wrap Up","index":2,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Topics in this Episode"]
[]
[null,"Mystery in Excel: How can you AutoSum at the top of a column of numbers?"]
[null,"Does anyone have a great solution? Note it in the YouTube comments. Win a prize."]
[null,"My lame solution is a macro"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"To download this workbook: https://www.mrexcel.com/download-center/2018/06/autosum-from-top.xlsx"]
[null,"List of upcoming seminars: https://www.mrexcel.com/press-appearances/"]
[]
[null,"To download the workbook from today's video, visit the URL in the YouTube description"]
[]
[null,"Title Image Photo Credit: Photo by Oliver Schwendener on Unsplash"]