{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Problem","Solution"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Problem","index":0,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[[122,1,122,9],[146,1,146,9],[69,16,69,17],[70,16,70,17],[71,16,71,17],[72,16,72,17],[74,1,74,9],[98,1,98,9],[68,16,68,17],[57,16,57,17],[58,16,58,17],[59,16,59,17],[60,16,60,17],[61,16,61,17],[62,16,62,17],[63,16,63,17],[64,16,64,17],[65,16,65,17],[66,16,66,17],[67,16,67,17],[56,16,56,17],[1,1,1,10],[49,1,49,9],[53,16,53,17],[54,16,54,17],[55,16,55,17]]}
[]
[null,"Excel SUM Function Practice Exercises"]
[]
[null,"Exercise 01 Add Consecutive Cells:"]
[null,"Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales","Time Worked"]
[null,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82,null,"<<< Use Formula in K6:K25"]
[null,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[]
[null,"Exercise 02 Aggregate Non-consecutive Cells:"]
[null,"No.","Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales"]
[null,1,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,2,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,3,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,4,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,5,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,6,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,7,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,8,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,9,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82]
[null,10,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,11,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,12,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,13,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,14,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,15,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,16,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,17,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,18,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,19,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,20,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[]
[null,"Summation of Sales for Odd Position",null,null,null,null,null,null,null,null,null,"<<< Use formula Here"]
[]
[null,"Exercise 03 Summation of Entire Row:"]
[null,"Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Size","Overtime","Other Work"]
[null,"Zachery",8,8,7,7,5,"Burger","Small",1,2]
[null,"Sada",6,5,6,7,7,"Sandwich","Small","-"]
[null,"Kenneth",6,6,6,6,8,"Sandwich","Medium","-"]
[null,"Ashlee",7,8,7,7,8,"Hotdog","Small","-"]
[null,"Loretta",6,7,7,5,5,"Burger","Small","-"]
[null,"Tabby",5,8,8,6,5,"Hotdog","Medium",2,3]
[null,"Salli",7,5,5,8,8,"Burger","Small","-"]
[null,"Jammal",6,8,5,6,5,"Pizza","Large","-"]
[null,"Northrop",5,6,7,8,5,"Sandwich","Small",1,1]
[null,"Rutledge",5,5,7,7,5,"Burger","Medium","-"]
[null,"Sabra",7,7,8,6,8,"Pizza","Large",1,2]
[null,"Perry",8,7,8,5,5,"Sandwich","Medium","-"]
[null,"Roman",8,7,8,7,7,"Pizza","Small","-"]
[null,"Luciana",5,5,6,8,5,"Sandwich","Medium","-"]
[null,"Ashlin",6,7,6,5,6,"Sandwich","Large","-"]
[null,"Marlee",7,8,7,5,7,"Sandwich","Large","-",2]
[null,"Morley",8,8,6,6,5,"Hotdog","Small","-"]
[null,"Maxy",6,5,8,6,5,"Burger","Large","-",3]
[null,"Athena",7,6,8,5,6,"Hotdog","Medium",2]
[null,"Miran",7,6,6,6,6,"Hotdog","Medium","-",1]
[]
[null,"Total Time Worked by Salli",null,null,null,null,null,null,null,null,null,"<<< Use Formula Here"]
[]
[null,"Exercise 04 Use Shortcut to Get Total Value:"]
[null,"No.","Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales"]
[null,1,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,2,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,3,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,4,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,5,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,6,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,7,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,8,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,9,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82]
[null,10,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,11,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,12,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,13,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,14,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,15,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,16,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,17,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,18,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,19,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,20,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[null,"Summation of Sales",null,null,null,null,null,null,null,null,null,"<<< Use AutoSum Shortcut Here"]
[]
[null,"Exercise 05 Add Values based on Criteria by Inserting a Helper Column:"]
[null,"Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales","Helper Column"]
[null,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82,null,"<<< Use SUMIF Function in K101:K120 Range"]
[null,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[null,"Summation of Sales",null,null,null,null,null,null,null,null,null,"<<< Use SUM Function here"]
[]
[null,"Exercise 06 VBA SUM Function:"]
[null,"No.","Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales"]
[null,1,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,2,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,3,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,4,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,5,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,6,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,7,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,8,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,9,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82]
[null,10,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,11,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,12,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,13,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,14,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,15,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,16,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,17,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,18,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,19,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,20,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[null,"Summation of Sales",null,null,null,null,null,null,null,null,null,"<<< VBA Output to this Cell"]

{"sheet":"Solution","index":1,"n_rows":147,"n_cols":12,"rows_kept":147,"cut":false,"hidden":false,"merged":[[146,1,146,9],[74,1,74,9],[98,1,98,9],[49,1,49,9],[122,1,122,9],[72,16,72,17],[64,16,64,17],[65,16,65,17],[66,16,66,17],[67,16,67,17],[68,16,68,17],[62,16,62,17],[63,16,63,17],[69,16,69,17],[70,16,70,17],[71,16,71,17],[57,16,57,17],[58,16,58,17],[59,16,59,17],[60,16,60,17],[61,16,61,17],[1,1,1,10],[53,16,53,17],[54,16,54,17],[55,16,55,17],[56,16,56,17]]}
[]
[null,"Excel SUM Function Practice Exercises"]
[]
[null,"Exercise 01 Add Consecutive Cells:"]
[null,"Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales","Time Worked"]
[null,"Zachery",8,8,7,7,5,"Burger",226,1353.74,{"$f":"SUM(C6:G6)","v":35}]
[null,"Sada",6,5,6,7,7,"Sandwich",271,1352.29,{"$f":"SUM(C7:G7)","v":31}]
[null,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53,32]
[null,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3,37]
[null,"Loretta",6,7,7,5,5,"Burger",272,1629.28,30]
[null,"Tabby",5,8,8,6,5,"Hotdog",265,792.35,32]
[null,"Salli",7,5,5,8,8,"Burger",261,1563.39,33]
[null,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001,30]
[null,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82,31,"<<< Use Formula in K6:K25"]
[null,"Rutledge",5,5,7,7,5,"Burger",218,1305.82,29]
[null,"Sabra",7,7,8,6,8,"Pizza",108,1294.92,36]
[null,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005,33]
[null,"Roman",8,7,8,7,7,"Pizza",118,1414.82,37]
[null,"Luciana",5,5,6,8,5,"Sandwich",56,279.44,29]
[null,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68,30]
[null,"Marlee",7,8,7,5,7,"Sandwich",149,743.51,34]
[null,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003,33]
[null,"Maxy",6,5,8,6,5,"Burger",260,1557.4,30]
[null,"Athena",7,6,8,5,6,"Hotdog",89,266.11,32]
[null,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004,31]
[]
[null,"Exercise 02 Aggregate Non-consecutive Cells:"]
[null,"No.","Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales"]
[null,1,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,2,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,3,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,4,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,5,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,6,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,7,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,8,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,9,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82]
[null,10,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,11,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,12,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,13,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,14,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,15,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,16,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,17,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,18,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,19,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,20,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[]
[null,"Summation of Sales for Odd Position",null,null,null,null,null,null,null,null,{"$f":"SUM(K29,K31,K33,K35,K37,K39,K41,K43,K45,K47)","v":11308.26},"<<< Use formula Here"]
[]
[null,"Exercise 03 Summation of Entire Row:"]
[null,"Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Size","Overtime","Other Work"]
[null,"Zachery",8,8,7,7,5,"Burger","Small",1,2]
[null,"Sada",6,5,6,7,7,"Sandwich","Small","-"]
[null,"Kenneth",6,6,6,6,8,"Sandwich","Medium","-"]
[null,"Ashlee",7,8,7,7,8,"Hotdog","Small","-"]
[null,"Loretta",6,7,7,5,5,"Burger","Small","-"]
[null,"Tabby",5,8,8,6,5,"Hotdog","Medium",2,3]
[null,"Salli",7,5,5,8,8,"Burger","Small","-"]
[null,"Jammal",6,8,5,6,5,"Pizza","Large","-"]
[null,"Northrop",5,6,7,8,5,"Sandwich","Small",1,1]
[null,"Rutledge",5,5,7,7,5,"Burger","Medium","-"]
[null,"Sabra",7,7,8,6,8,"Pizza","Large",1,2]
[null,"Perry",8,7,8,5,5,"Sandwich","Medium","-"]
[null,"Roman",8,7,8,7,7,"Pizza","Small","-"]
[null,"Luciana",5,5,6,8,5,"Sandwich","Medium","-"]
[null,"Ashlin",6,7,6,5,6,"Sandwich","Large","-"]
[null,"Marlee",7,8,7,5,7,"Sandwich","Large","-",2]
[null,"Morley",8,8,6,6,5,"Hotdog","Small","-"]
[null,"Maxy",6,5,8,6,5,"Burger","Large","-",3]
[null,"Athena",7,6,8,5,6,"Hotdog","Medium",2]
[null,"Miran",7,6,6,6,6,"Hotdog","Medium","-",1]
[]
[null,"Total Time Worked by Salli",null,null,null,null,null,null,null,null,{"$f":"SUM(60:60)","v":33},"<<< Use Formula Here"]
[]
[null,"Exercise 04 Use Shortcut to Get Total Value:"]
[null,"No.","Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales"]
[null,1,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,2,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,3,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,4,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,5,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,6,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,7,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,8,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,9,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82]
[null,10,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,11,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,12,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,13,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,14,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,15,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,16,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,17,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,18,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,19,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,20,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[null,"Summation of Sales",null,null,null,null,null,null,null,null,{"$f":"SUM(K79:K98)","v":19647.600000000006},"<<< Use AutoSum Shortcut Here"]
[]
[null,"Exercise 05 Add Values based on Criteria by Inserting a Helper Column:"]
[null,"Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales","Helper Column"]
[null,"Zachery",8,8,7,7,5,"Burger",226,1353.74,{"$f":"SUMIF(C103:G103,\">=\"&8)","v":16}]
[null,"Sada",6,5,6,7,7,"Sandwich",271,1352.29,{"$f":"SUMIF(C104:G104,\">=\"&8)","v":0}]
[null,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53,8]
[null,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3,16]
[null,"Loretta",6,7,7,5,5,"Burger",272,1629.28,0]
[null,"Tabby",5,8,8,6,5,"Hotdog",265,792.35,16]
[null,"Salli",7,5,5,8,8,"Burger",261,1563.39,16]
[null,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001,8]
[null,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82,8,"<<< Use SUMIF Function in K101:K120 Range"]
[null,"Rutledge",5,5,7,7,5,"Burger",218,1305.82,0]
[null,"Sabra",7,7,8,6,8,"Pizza",108,1294.92,16]
[null,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005,16]
[null,"Roman",8,7,8,7,7,"Pizza",118,1414.82,16]
[null,"Luciana",5,5,6,8,5,"Sandwich",56,279.44,8]
[null,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68,0]
[null,"Marlee",7,8,7,5,7,"Sandwich",149,743.51,8]
[null,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003,16]
[null,"Maxy",6,5,8,6,5,"Burger",260,1557.4,8]
[null,"Athena",7,6,8,5,6,"Hotdog",89,266.11,8]
[null,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004,0]
[null,"Summation of Sales",null,null,null,null,null,null,null,null,{"$f":"SUM(K103:K122)","v":184},"<<< Use SUM Function here"]
[]
[null,"Exercise 06 VBA SUM Function:"]
[null,"No.","Salesperson","2022-11-11","2022-11-12","2022-11-13","2022-11-14","2022-11-15","Product","Unit Sold","Sales"]
[null,1,"Zachery",8,8,7,7,5,"Burger",226,1353.74]
[null,2,"Sada",6,5,6,7,7,"Sandwich",271,1352.29]
[null,3,"Kenneth",6,6,6,6,8,"Sandwich",247,1232.53]
[null,4,"Ashlee",7,8,7,7,8,"Hotdog",70,209.3]
[null,5,"Loretta",6,7,7,5,5,"Burger",272,1629.28]
[null,6,"Tabby",5,8,8,6,5,"Hotdog",265,792.35]
[null,7,"Salli",7,5,5,8,8,"Burger",261,1563.39]
[null,8,"Jammal",6,8,5,6,5,"Pizza",86,1031.1400000000001]
[null,9,"Northrop",5,6,7,8,5,"Sandwich",218,1087.82]
[null,10,"Rutledge",5,5,7,7,5,"Burger",218,1305.82]
[null,11,"Sabra",7,7,8,6,8,"Pizza",108,1294.92]
[null,12,"Perry",8,7,8,5,5,"Sandwich",99,494.01000000000005]
[null,13,"Roman",8,7,8,7,7,"Pizza",118,1414.82]
[null,14,"Luciana",5,5,6,8,5,"Sandwich",56,279.44]
[null,15,"Ashlin",6,7,6,5,6,"Sandwich",232,1157.68]
[null,16,"Marlee",7,8,7,5,7,"Sandwich",149,743.51]
[null,17,"Morley",8,8,6,6,5,"Hotdog",103,307.97000000000003]
[null,18,"Maxy",6,5,8,6,5,"Burger",260,1557.4]
[null,19,"Athena",7,6,8,5,6,"Hotdog",89,266.11]
[null,20,"Miran",7,6,6,6,6,"Hotdog",192,574.08000000000004]
[null,"Summation of Sales",null,null,null,null,null,null,null,null,19647.600000000006,"<<< VBA Output to this Cell"]