{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Contents","Introduction AVERAGEIF","Example 01","Example 02","Example 03","Example 04","Example 05","Example 6","Example 7","Example 8","Example 9 DATE","Example 9 AGE","Example 10","Example 11","Example 12","Example 13","Example 14"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["MEDIAN Function"]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"Introduction AVERAGEIF",null,null,null,"Excel Formulas w/Examples"]
[null,"Example 01",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Example 02",null,null,null,"Excel Functions & Formulas Tutorial"]
[null,"Example 03"]
[null,"Example 04"]
[null,"Example 05"]
[null,"Example 6"]
[null,"Example 7"]
[null,"Example 8"]
[null,"Example 9 DATE"]
[null,"Example 9 AGE"]
[null,"Example 10"]
[null,"Example 11"]
[null,"Example 12"]
[null,"Example 13"]
[null,"Example 14"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"Introduction AVERAGEIF","index":1,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MEDIAN",null,"=MEDIAN (number1, [number2], ...)"]
[]
[null,"The MEDIAN function returns the median (middle number) in a group of supplied numbers."]
[]
[null,"JOB","Factory 01","Factory 02","Factory 03",null,"Median"]
[null,"Electrician",90,100,105,null,{"$f":"MEDIAN(C7:E7)","v":100}]
[null,"Technician",102,114,116,null,{"$f":"MEDIAN(C8:E8)","v":114}]
[null,"Nurse",105,106,101,null,105]
[null,"Operator",112,91,93,null,93]
[null,"Sales Manger",98,117,107,null,107]
[null,"Superviser",103,90,120,null,103]
[null,"Helper",108,111,93,null,108]
[]
[null,"Median",{"$f":"MEDIAN(C7:C13)","v":103},{"$f":"MEDIAN(D7:D13)","v":106},105]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 01","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Students","Test Scores",null,"Result"]
["John",5,null,{"$f":"MEDIAN(B2:B8)","v":18}]
["Bob",9]
["Mary",14]
["Pam",18]
["Kim",24]
["Andy",28]
["Harry",37]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 02","index":3,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Students","Test Scores",null,"Result"]
["John",5,null,{"$f":"MEDIAN(B2:B7)","v":16}]
["Bob",9]
["Mary",14]
["Pam",18]
["Kim",24]
["Andy",28]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 03","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Laptops Brand","Price ($)",null,"Item","Result"]
["Lenovo",228.125,null,"Mean Price ",{"$f":"AVERAGE(B2:B6)","v":642.375}]
["HP",365.625,null,"Median Price ",{"$f":"MEDIAN(B2:B6)","v":371.875}]
["Dell",371.875]
["Acer",499.375]
["MSI",1746.875]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 04","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Employees","Monthly Salary",null,"Item","Result"]
["Receptionist",27965,null,"Median Salary ",{"$f":"MEDIAN(B2:B6)","v":58419}]
["Marketing",54268]
["Salesperson",58419]
["Human Resource",67252]
["Accountant",121770]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 05","index":6,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Employees","Monthly Salary",null,"Item","Result"]
["Receptionist",27965,null,"Median Salary ",{"$f":"MEDIAN(B2:B7)","v":62835.5}]
["Marketing",54268]
["Salesperson",58419]
["Human Resource",67252]
["Accountant",121770]
["CEO",156770]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 6","index":7,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Data ","Value"]
["2020-06-09",{"$f":"VALUE(A2)","v":43991}]
[793,{"$f":"VALUE(A3)","v":793}]
["2007-07-10",{"$f":"VALUE(A4)","v":39273}]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 7","index":8,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Date of Birth","Value"]
["1992-05-09",{"$f":"VALUE(A2)","v":33733}]
["1995-04-02",34791]
["1990-08-02",33087]
["1996-09-23",35331]
["1998-04-29",35914]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 8","index":9,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Employees","Date of Birth",null,"Item","Result"]
["Accountant","1998-04-29",null,"Median Date of Birth ",{"$f":"MEDIAN(B2:B6)","v":"1995-04-02"}]
["Human Resource","1996-09-23"]
["Marketing","1995-04-02"]
["Receptionist","1992-05-09"]
["Salesperson","1990-08-02"]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 9 DATE","index":10,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Employees","Date of Birth","Age",null,"Item ","Result"]
["Accountant","1998-04-29",{"$f":"INT(YEARFRAC(B2,TODAY()))","v":23},null,"Median Date of Birth ",{"$f":"MEDIAN(B2:B6)","v":"1995-04-02"}]
["Human Resource","1996-09-23",{"$f":"INT(YEARFRAC(B3,TODAY()))","v":24}]
["Marketing","1995-04-02",{"$f":"INT(YEARFRAC(B4,TODAY()))","v":26}]
["Receptionist","1992-05-09",{"$f":"INT(YEARFRAC(B5,TODAY()))","v":29}]
["Salesperson","1990-08-02",{"$f":"INT(YEARFRAC(B6,TODAY()))","v":31}]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 9 AGE","index":11,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Employees","Date of Birth","Age",null,"Item ","Result"]
["Accountant","1998-04-29",{"$f":"INT(YEARFRAC(B2,TODAY()))","v":23},null,"Median Age",{"$f":"MEDIAN(C2:C6)","v":26}]
["Human Resource","1996-09-23",{"$f":"INT(YEARFRAC(B3,TODAY()))","v":24}]
["Marketing","1995-04-02",{"$f":"INT(YEARFRAC(B4,TODAY()))","v":26}]
["Receptionist","1992-05-09",{"$f":"INT(YEARFRAC(B5,TODAY()))","v":29}]
["Salesperson","1990-08-02",{"$f":"INT(YEARFRAC(B6,TODAY()))","v":31}]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 10","index":12,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Employees","Date of Birth","Age",null,"Employees","Date of Birth"]
[null,"Accountant","1998-04-29",{"$f":"INT(YEARFRAC(C3,TODAY()))","v":23},null,"Accountant","1998-04-29"]
[null,"Human Resource","1996-09-23",{"$f":"INT(YEARFRAC(C4,TODAY()))","v":24},null,"Human Resource","1996-09-23"]
[null,"Marketing","1995-04-02",{"$f":"INT(YEARFRAC(C5,TODAY()))","v":26},null,"Marketing","1995-04-02"]
[null,"Receptionist","1992-05-09",{"$f":"INT(YEARFRAC(C6,TODAY()))","v":29},null,"Receptionist","1992-05-09"]
[null,"Salesperson","1990-08-02",{"$f":"INT(YEARFRAC(C7,TODAY()))","v":31},null,"Salesperson","1990-08-02"]
[]
[null,null,null,null,null,"Median Date of Birth ",{"$f":"MEDIAN(G3:G7)","v":"1995-04-02"}]
[null,null,"Median Age",{"$f":"MEDIAN(D3:D8)","v":26},null,"Corresponding Age ",{"$f":"DATEDIF(G9, TODAY(), \"y\")","v":26}]
[]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 11","index":13,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Laptops Brand","Release Year","Price ($)",null,"Item ","Result"]
["HP Chromebook",2018,385,null,"Median Price",{"$f":"MEDIAN(C2:C11)","v":1353.5}]
["HP Stream 11",2019,400]
["HP 340S",2019,515]
["HP 250",2017,612]
["HP Notebook",2017,1069]
["HP Elitebook",2018,1638]
["HP Elite X2",2018,1663]
["HP Elite Dragonfly",2018,1779]
["HP Probook",2017,1820]
["HP Zbook Studio",2019,2259]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 12","index":14,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Laptops Brand","Release Year","Price ($)",null,"Release Year","Average Price"]
["HP Chromebook",2018,385,null,2017,{"$f":"AVERAGEIF($B$2:$B$11, $E2, $C$2:$C$11)","v":1167}]
["HP Stream 11",2019,400,null,2018,{"$f":"AVERAGEIF($B$2:$B$11, $E3, $C$2:$C$11)","v":1366.25}]
["HP 340S",2019,515,null,2019,{"$f":"AVERAGEIF($B$2:$B$11, $E4, $C$2:$C$11)","v":1058}]
["HP 250",2017,612]
["HP Notebook",2017,1069]
["HP Elitebook",2018,1638]
["HP Elite X2",2018,1663]
["HP Elite Dragonfly",2018,1779]
["HP Probook",2017,1820]
["HP Zbook Studio",2019,2259]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 13","index":15,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Laptops Brand","Release Year","Price ($)",null,"Release Year","Median Price"]
["HP Chromebook",2018,385,null,2017,{"$f":"MEDIAN(IF($B$2:$B$11 = $E2, $C$2:$C$11))","v":1069}]
["HP Stream 11",2019,400,null,2018,{"$f":"MEDIAN(IF($B$2:$B$11 = $E3, $C$2:$C$11))","v":1650.5}]
["HP 340S",2019,515,null,2019,{"$f":"MEDIAN(IF($B$2:$B$11 = $E4, $C$2:$C$11))","v":515}]
["HP 250",2017,612]
["HP Notebook",2017,1069]
["HP Elitebook",2018,1638]
["HP Elite X2",2018,1663]
["HP Elite Dragonfly",2018,1779]
["HP Probook",2017,1820]
["HP Zbook Studio",2019,2259]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Example 14","index":16,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Laptops Brand","Release Year","Price ($)",null,"Release Year","Median Price"]
[null,"HP Chromebook",2018,385,null,2017,{"$f":"MEDIAN(IF(C3:C12 = F3, D3:D12))","v":1069}]
[null,"HP Stream 11",2019,400,null,2018,{"$f":"MEDIAN(IF(C4:C12 = F4, D4:D12))","v":1663}]
[null,"HP 340S",2019,515,null,2019,{"$f":"MEDIAN(IF(C5:C13 = F5, D5:D13))","v":1387}]
[null,"HP 250",2017,612]
[null,"HP Notebook",2017,1069]
[null,"HP Elitebook",2018,1638]
[null,"HP Elite X2",2018,1663]
[null,"HP Elite Dragonfly",2018,1779]
[null,"HP Probook",2017,1820]
[null,"HP Zbook Studio",2019,2259]
[]
[null,"automateexcel.com/functions/median-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]