{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","COUNT","SUMIFS","IF","Filter","VBA","Practice"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Execute Excel Functions If Cell Color is Red"]
[]
[null,"Player Name","Team","Salary"]
[null,"Robert Lewandowski","Barcelona",450000]
[null,"Eden Hazard","Real Madrid",650000]
[null,"Lionel Messi","Paris Saint-Germain",950000]
[null,"Raphinha","Barcelona",420000]
[null,"Ansu Fati","Barcelona",550000]
[null,"Cristiano Ronaldo","Manchester United",845000]
[null,"Neymar","Paris Saint-Germain",750000]
[null,"Dembele","Barcelona",650000]

{"sheet":"COUNT","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Counting Red Color Cells"]
[]
[null,"Player Name","Team","Salary","Color Code"]
[null,"Robert Lewandowski","Barcelona",450000,{"$f":"Identify_Red","v":3}]
[null,"Eden Hazard","Real Madrid",650000,{"$f":"Identify_Red","v":36}]
[null,"Lionel Messi","Paris Saint-Germain",950000,{"$f":"Identify_Red","v":37}]
[null,"Raphinha","Barcelona",420000,{"$f":"Identify_Red","v":3}]
[null,"Ansu Fati","Barcelona",550000,{"$f":"Identify_Red","v":3}]
[null,"Cristiano Ronaldo","Manchester United",845000,{"$f":"Identify_Red","v":36}]
[null,"Neymar","Paris Saint-Germain",750000,{"$f":"Identify_Red","v":40}]
[null,"Dembele","Barcelona",650000,{"$f":"Identify_Red","v":3}]
[]
[]
[null,"Number of Red Cells",{"$f":"COUNTIFS(E5:E12,3)","v":4}]

{"sheet":"SUMIFS","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Calculate Summation When Cell Color is Red"]
[]
[null,"Player Name","Team","Salary","Color Code"]
[null,"Robert Lewandowski","Barcelona",450000,{"$f":"Identify_Red","v":3}]
[null,"Eden Hazard","Real Madrid",650000,{"$f":"Identify_Red","v":36}]
[null,"Lionel Messi","Paris Saint-Germain",950000,{"$f":"Identify_Red","v":37}]
[null,"Raphinha","Barcelona",420000,{"$f":"Identify_Red","v":3}]
[null,"Ansu Fati","Barcelona",550000,{"$f":"Identify_Red","v":3}]
[null,"Cristiano Ronaldo","Manchester United",845000,{"$f":"Identify_Red","v":36}]
[null,"Neymar","Paris Saint-Germain",750000,{"$f":"Identify_Red","v":40}]
[null,"Dembele","Barcelona",650000,{"$f":"Identify_Red","v":3}]
[]
[]
[null,"Total Salary in Red Cells",{"$f":"SUMIF(E5:E12,3,D5:D12)","v":2070000}]

{"sheet":"IF","index":3,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using IF Function in Red Color Cells"]
[]
[null,"Player Name","Team","Salary","Color Code"]
[null,"Robert Lewandowski","Barcelona",450000,{"$f":"IF(Identify_Red=3, D5*(1-$C$14),D5)","v":337500}]
[null,"Eden Hazard","Real Madrid",650000,{"$f":"IF(Identify_Red=3, D6*(1-$C$14),D6)","v":650000}]
[null,"Lionel Messi","Paris Saint-Germain",950000,{"$f":"IF(Identify_Red=3, D7*(1-$C$14),D7)","v":950000}]
[null,"Raphinha","Barcelona",420000,{"$f":"IF(Identify_Red=3, D8*(1-$C$14),D8)","v":315000}]
[null,"Ansu Fati","Barcelona",550000,{"$f":"IF(Identify_Red=3, D9*(1-$C$14),D9)","v":412500}]
[null,"Cristiano Ronaldo","Manchester United",845000,{"$f":"IF(Identify_Red=3, D10*(1-$C$14),D10)","v":845000}]
[null,"Neymar","Paris Saint-Germain",750000,{"$f":"IF(Identify_Red=3, D11*(1-$C$14),D11)","v":750000}]
[null,"Dembele","Barcelona",650000,{"$f":"IF(Identify_Red=3, D12*(1-$C$14),D12)","v":487500}]
[]
[null,"Salary Reduction",0.25]

{"sheet":"Filter","index":4,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Utilizing Filter and SUBTOTAL Function"]
[]
[null,"Player Name","Team","Salary"]
[null,"Robert Lewandowski","Barcelona",450000]
[null,"Eden Hazard","Real Madrid",650000]
[null,"Lionel Messi","Paris Saint-Germain",950000]
[null,"Raphinha","Barcelona",420000]
[null,"Ansu Fati","Barcelona",550000]
[null,"Cristiano Ronaldo","Manchester United",845000]
[null,"Neymar","Paris Saint-Germain",750000]
[null,"Dembele","Barcelona",650000]
[]
[null,"Total Salary in Red Cells",{"$f":"SUBTOTAL(109,D5:D12)","v":2070000}]

{"sheet":"VBA","index":5,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Applying VBA to Find Summation of Red Color Cells"]
[]
[null,"Player Name","Team","Salary"]
[null,"Robert Lewandowski","Barcelona",450000]
[null,"Eden Hazard","Real Madrid",650000]
[null,"Lionel Messi","Paris Saint-Germain",950000]
[null,"Raphinha","Barcelona",420000]
[null,"Ansu Fati","Barcelona",550000]
[null,"Cristiano Ronaldo","Manchester United",845000]
[null,"Neymar","Paris Saint-Germain",750000]
[null,"Dembele","Barcelona",650000]
[]
[null,"Color"]
[null,"Total Salary in Red Cells",{"$f":"Red_Cells_Summation(C14,$D$5:$D$12)","v":2070000}]

{"sheet":"Practice","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Try Yourself"]
[]
[null,"Player Name","Team","Salary"]
[null,"Robert Lewandowski","Barcelona",450000]
[null,"Eden Hazard","Real Madrid",650000]
[null,"Lionel Messi","Paris Saint-Germain",950000]
[null,"Raphinha","Barcelona",420000]
[null,"Ansu Fati","Barcelona",550000]
[null,"Cristiano Ronaldo","Manchester United",845000]
[null,"Neymar","Paris Saint-Germain",750000]
[null,"Dembele","Barcelona",650000]