{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["AVERAGEIF","SUMPRODUCT & AVERAGE","SUM & ROWS","Excel 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":"AVERAGEIF","index":0,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,1,10,3],[1,1,1,4]]}
[]
[null,"Use of AVERAGEIF Function"]
[]
[null,"Seller ID","File Month","Salesperson","Check Amount"]
[null,1301,"January","Andy Teal",80000]
[null,1307,"February","Kim Ralls",40000]
[null,1309,"March","Susan W. Eaton",15000]
[null,1321,"April",null,50000]
[null,1327,"May","Kathie Flood",30000]
[]
[null,"Average",null,null,{"$f":"AVERAGEIF(D5:D9,\"\",E5:E9)","v":50000}]

{"sheet":"SUMPRODUCT & AVERAGE","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,3]]}
[]
[null,"Combining SUMPRODUCT & AVERAGE Functions"]
[]
[null,"Seller ID","File Month","Salesperson","Check Amount"]
[null,1301,"January","Andy Teal",80000]
[null,1307,"February","Kim Ralls",40000]
[null,1309,"March","Susan W. Eaton"]
[null,1321,"April",null,50000]
[null,1327,"May","Kathie Flood",30000]
[]
[null,"Average",null,null,{"$f":"SUMPRODUCT(AVERAGE(0+E5:E9))","v":40000}]

{"sheet":"SUM & ROWS","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,3]]}
[]
[null,"Combination of SUM & ROWS Functions"]
[]
[null,"Seller ID","File Month","Salesperson","Check Amount"]
[null,1301,"January","Andy Teal",80000]
[null,1307,"February","Kim Ralls",40000]
[null,1309,"March","Susan W. Eaton"]
[null,1321,"April",null,50000]
[null,1327,"May","Kathie Flood",30000]
[]
[null,"Average",null,null,{"$f":"SUM(E5:E9)/ROWS(E5:E9)","v":40000}]

{"sheet":"Excel VBA","index":3,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[10,1,10,3]]}
[]
[null,"Running a VBA Code"]
[]
[null,"Seller ID","File Month","Salesperson","Check Amount"]
[null,1301,"January","Andy Teal",80000]
[null,1307,"February","Kim Ralls",40000]
[null,1309,"March","Susan W. Eaton",15000]
[null,1321,"April",null,50000]
[null,1327,"May","Kathie Flood",30000]
[]
[null,"Average",null,null,50000]