{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","AVERAGEIF Function","AVERAGEIFS Function","VBA Code","AVERAGE and AVERAGEIF Functions","IF, ISNUMBER & MATCH Functions","Match Text Exactly","Match Text Partially","Cell Does Not Contain Text"],"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,"Sales and Profit based on Location"]
[]
[null,"Location","Sales","Profit"]
[null,"Alabama",2466,877]
[null,"Alabama",3422,1333]
[null,"Alabama",2501,1260]
[null,"Chicago",2345,930]
[null,"Chicago",1210,550]
[null,"Dakota",1661,1040]
[null,"Dakota",3740,917]
[null,"Dakota",3084,559]
[null,"Utah",2975,1263]
[null,"Utah",4525,1102]

{"sheet":"AVERAGEIF Function","index":1,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using AVERAGEIF Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","Chicago",null,null,null,null,null,null,null,null,"Criteria"]
[]
[null,"Average Sales",{"$f":"AVERAGEIF(B5:B14,C16,C5:C14)","v":1777.5},null,null,null,null,null,null,null,null,"Average Sales"]

{"sheet":"AVERAGEIFS Function","index":2,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Using AVERAGEIFS Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","Chicago",null,null,null,null,null,null,null,null,"Criteria"]
[]
[null,"Average Sales",{"$f":"AVERAGEIFS(C5:C14,B5:B14,C16)","v":1777.5},null,null,null,null,null,null,null,null,"Average Sales"]

{"sheet":"VBA Code","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","Alabama",null,null,null,null,null,null,null,null,"Criteria"]
[]
[null,"Average Profit",1156.6666666666667,null,null,null,null,null,null,null,null,"Average Profit"]

{"sheet":"AVERAGE and AVERAGEIF Functions","index":4,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,16,1],[1,1,1,3],[1,11,1,13],[15,11,16,11]]}
[]
[null,"Combining AVERAGE and AVERAGEIF Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","Chicago",null,null,null,null,null,null,null,null,"Criteria"]
[null,null,"Utah"]
[]
[null,"Average Profit",{"$f":"AVERAGE(AVERAGEIF(B5:B14,C16,D5:D14),\nAVERAGEIF(B5:B14,C17,D5:D14))","v":961.25},null,null,null,null,null,null,null,null,"Average Profit"]

{"sheet":"IF, ISNUMBER & MATCH Functions","index":5,"n_rows":19,"n_cols":14,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,1,16,1],[1,1,1,3],[1,11,1,13],[15,11,16,11]]}
[]
[null,"Using IF, ISNUMBER, and MATCH Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","Chicago",null,null,null,null,null,null,null,null,"Criteria"]
[null,null,"Utah"]
[]
[null,"Average Profit",{"$f":"AVERAGE(IF(ISNUMBER(MATCH(B5:B14,\n C16:C17, 0)), D5:D14))","v":961.25},null,null,null,null,null,null,null,null,"Average Profit"]

{"sheet":"Match Text Exactly","index":6,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Averaging Cells that Matches Text Exactly",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","ta",null,null,null,null,null,null,null,null,"Criteria"]
[]
[null,"Average Sales",{"$f":"AVERAGEIF(B5:B14,\"*ta*\",C5:C14)","v":3197},null,null,null,null,null,null,null,null,"Average Sales"]

{"sheet":"Match Text Partially","index":7,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Averaging Cells that Matches Text Partially",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","ta",null,null,null,null,null,null,null,null,"Criteria"]
[]
[null,"Average Sales",{"$f":"AVERAGEIF(B5:B14,\"*ta\",C5:C14)","v":2828.3333333333335},null,null,null,null,null,null,null,null,"Average Sales"]

{"sheet":"Cell Does Not Contain Text","index":8,"n_rows":18,"n_cols":14,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,11,1,13]]}
[]
[null,"Averaging Cells that Does Not Contain Text",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Location","Sales","Profit",null,null,null,null,null,null,null,"Location","Sales","Profit"]
[null,"Alabama",2466,877,null,null,null,null,null,null,null,"Alabama",2466,877]
[null,"Alabama",3422,1333,null,null,null,null,null,null,null,"Alabama",3422,1333]
[null,"Alabama",2501,1260,null,null,null,null,null,null,null,"Alabama",2501,1260]
[null,"Chicago",2345,930,null,null,null,null,null,null,null,"Chicago",2345,930]
[null,"Chicago",1210,550,null,null,null,null,null,null,null,"Chicago",1210,550]
[null,"Dakota",1661,1040,null,null,null,null,null,null,null,"Dakota",1661,1040]
[null,"Dakota",3740,917,null,null,null,null,null,null,null,"Dakota",3740,917]
[null,"Dakota",3084,559,null,null,null,null,null,null,null,"Dakota",3084,559]
[null,"Utah",2975,1263,null,null,null,null,null,null,null,"Utah",2975,1263]
[null,"Utah",4525,1102,null,null,null,null,null,null,null,"Utah",4525,1102]
[]
[null,"Criteria","Dakota",null,null,null,null,null,null,null,null,"Criteria"]
[]
[null,"Average Sales",{"$f":"AVERAGEIF(B5:B14,\"<>*Dakota*\",C5:C14)","v":2777.7142857142858},null,null,null,null,null,null,null,null,"Average Sales"]