{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Index -->","1. IF","2. SUM","2. SUMIF","2. SUMIFS","3. COUNT","3. COUNTIF","3. COUNTIFS","4. AVERAGE&AVERAGEIF","5. LEFT, RIGHT, MID","5. UPPER, LOWER & PROPER","5. &,CONCATENATE","6. MAX,MIN","7. ROUND","8. VLOOKUP","8. HLOOKUP"],"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":"Index -->","index":0,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Functions "]
[null,"Sheet index"]
[]
[null,"#                ","Worksheet"]
[null,1,"IF"]
[null,2.1,"SUM"]
[null,2.2000000000000002,"SUMIF"]
[null,2.2999999999999998,"SUMIFS"]
[null,3.1,"COUNT"]
[null,3.2,"COUNTIF"]
[null,3.3,"COUNTIFS"]
[null,4,"AVERAGE & AVERAGEIF"]
[null,5.0999999999999996,"LEFT, RIGHT, MID"]
[null,5.2,"UPPER, LOWER & PROPER"]
[null,5.3,"&, CONCATENATE"]
[null,6,"MAX, MIN"]
[null,7,"ROUND"]
[null,8.1,"VLOOKUP"]
[null,8.1999999999999993,"HLOOKUP"]
[null,9.1,"INDEX"]
[null,9.1999999999999993,"MATCH"]
[null,9.3000000000000007,"INDEX & MATCH"]
[null,10,"IFERROR"]
[null,11,"CHOOSE"]
[null,12,"GOAL SEEK"]
[null,13,"DATA TABLES"]
[null,14,"PIVOT TABLES"]

{"sheet":"1. IF","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"1. IF"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71,null,{"$f":"IF(D4=\"Yes\",F4,0)","v":71}]
[null,"Milan","Italy","Yes",38,57,null,{"$f":"IF(D5=\"Yes\",F5,0)","v":57}]
[null,"Manchester United","England","Yes",38,64,null,64]
[null,"Hamburger","Germany","No",34,27,null,0]
[null,"Lazio","Italy","No",38,56,null,0]
[null,"Fiorentina","Italy","No",38,65,null,0]
[null,"Bayern","Germany","Yes",34,90,null,90]
[null,"Liverpool","England","No",38,84,null,0]
[null,"Arsenal","England","Yes",38,79,null,79]
[null,"Total"]

{"sheet":"2. SUM","index":2,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"2. SUM"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[null,"Total",null,null,{"$f":"+SUM(E4:E12)","v":330}]

{"sheet":"2. SUMIF","index":3,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,"2. SUMIF"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[null,"Total",null,null,{"$f":"SUM(E4:E12)","v":330},{"$f":"SUM(F4:F12)","v":593}]
[]
[]
[]
[]
[null,null,"Italy",null,{"$f":"SUMIF(C4:C12,C18,E4:E12)","v":114}]

{"sheet":"2. SUMIFS","index":4,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"2. SUMIFS"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[null,"Total",null,null,{"$f":"SUM(E4:E12)","v":330},{"$f":"SUM(F4:F12)","v":593}]
[]
[]
[null,null,"England","Yes",null,{"$f":"SUMIFS(F4:F12,C4:C12,C16,D4:D12,D16)","v":143}]

{"sheet":"3. COUNT","index":5,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"3. COUNT"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[]
[null,{"$f":"+COUNTA(B4:B12)","v":9}]

{"sheet":"3. COUNTIF","index":6,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"3. COUNTIF"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[]
[null,null,null,null,null,{"$f":"+COUNTIF(F4:F12,\">60\")","v":6}]

{"sheet":"3. COUNTIFS","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,"3. COUNTIFS"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[]
[null,null,null,null,null,{"$f":"COUNTIFS(D4:D12,\"Yes\",F4:F12,\">60\")","v":4}]

{"sheet":"4. AVERAGE&AVERAGEIF","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[null,"4. AVERAGE & AVERAGEIF"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,"n.a."]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[]
[]
[null,null,null,null,null,{"$f":"AVERAGEIF(D4:D12,\"Yes\",F4:F12)","v":72.2}]

{"sheet":"5. LEFT, RIGHT, MID","index":9,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[null,"5. LEFT, RIGHT, MID"]
[]
[]
[null,"Doppelkupplungsgetriebbe",null,null,"`"]
[null,"Doppelkupplungsgetriebbe",null,null,{"$f":"RIGHT(B5,3)","v":"bbe"}]
[null,"Doppelkupplungsgetriebbe",null,null,{"$f":"MID(B6,4,7)","v":"pelkupp"}]

{"sheet":"5. UPPER, LOWER & PROPER","index":10,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"5. UPPER, LOWER, & PROPER"]
[]
[null,"doppelkupplungsgetriEBBE",null,null,{"$f":"UPPER(B3)","v":"DOPPELKUPPLUNGSGETRIEBBE"}]
[null,"doppelkupplungsgetriEBBE",null,null,{"$f":"LOWER(B4)","v":"doppelkupplungsgetriebbe"}]
[null,"doppelkupplungsgetriEBBE",null,null,{"$f":"PROPER(B5)","v":"Doppelkupplungsgetriebbe"}]

{"sheet":"5. &,CONCATENATE","index":11,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"5. & and CONCATENATE"]
[]
[]
[null,"ABC",123,"CDE"]
[]
[null,null,{"$f":"B4&\" \"&C4&D4","v":"ABC 123CDE"}]
[null,null,{"$f":"CONCATENATE(B4,C4,D4)","v":"ABC123CDE"}]

{"sheet":"6. MAX,MIN","index":12,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"6. MAX & MIN"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71]
[null,"Milan","Italy","Yes",38,57]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]
[]
[]
[null,null,null,null,null,{"$f":"+MAX(F4:F12)","v":90}]
[null,null,null,null,null,{"$f":"MIN(F4:F12)","v":27}]

{"sheet":"7. ROUND","index":13,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"7. ROUND"]
[]
[]
[null,5.0999999999999996,null,{"$f":"ROUND(B4,0)","v":5}]
[null,0.05,null,{"$f":"ROUND(B5,1)","v":0.1}]

{"sheet":"8. VLOOKUP","index":14,"n_rows":12,"n_cols":12,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"8. VLOOKUP"]
[]
[null,"Team ","Country","Champions league","Games played","Points earned",null,"Team ","Country","Champions \nleague","Games played","Points earned"]
[null,"Borussia","Germany","Yes",34,71,null,"Lazio",{"$f":"+VLOOKUP($H4,$B$4:$F$12,2,FALSE)","v":"Italy"},{"$f":"+VLOOKUP($H4,$B$4:$F$12,3,FALSE)","v":"No"},{"$f":"+VLOOKUP($H4,$B$4:$F$12,4,FALSE)","v":38},{"$f":"+VLOOKUP($H4,$B$4:$F$12,5,FALSE)","v":56}]
[null,"Milan","Italy","Yes",38,57,null,"Borussia",{"$f":"+VLOOKUP(H5,$B$4:$F$12,2,FALSE)","v":"Germany"},{"$f":"+VLOOKUP($H5,$B$4:$F$12,3,FALSE)","v":"Yes"},{"$f":"+VLOOKUP($H5,$B$4:$F$12,4,FALSE)","v":34},{"$f":"+VLOOKUP($H5,$B$4:$F$12,5,FALSE)","v":71}]
[null,"Manchester United","England","Yes",38,64]
[null,"Hamburger","Germany","No",34,27]
[null,"Lazio","Italy","No",38,56]
[null,"Fiorentina","Italy","No",38,65]
[null,"Bayern","Germany","Yes",34,90]
[null,"Liverpool","England","No",38,84]
[null,"Arsenal","England","Yes",38,79]

{"sheet":"8. HLOOKUP","index":15,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"8. HLOOKUP"]
[]
[null,"Team ","Borussia","Milan","Manchester United","Hamburger",null,"Team ","Country","Champions \nleague","Games played","Points earned"]
[null,"Country","Germany","Italy","England","Germany",null,"Milan",{"$f":"+HLOOKUP($H4,$B$3:$F$7,2,FALSE)","v":"Italy"},{"$f":"+HLOOKUP($H4,$B$3:$F$7,3,FALSE)","v":"Yes"},{"$f":"+HLOOKUP($H4,$B$3:$F$7,4,FALSE)","v":38},{"$f":"+HLOOKUP($H4,$B$3:$F$7,5,FALSE)","v":57}]
[null,"Champions league","Yes","Yes","Yes","No",null,"Hamburger",{"$f":"+HLOOKUP($H5,$B$3:$F$7,2,FALSE)","v":"Germany"},{"$f":"+HLOOKUP($H5,$B$3:$F$7,3,FALSE)","v":"No"},{"$f":"+HLOOKUP($H5,$B$3:$F$7,4,FALSE)","v":34},{"$f":"+HLOOKUP($H5,$B$3:$F$7,5,FALSE)","v":27}]
[null,"Games played",34,38,38,34]
[null,"Points earned",71,57,64,27]