{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Cell range","Array","Cell ranges","Text and numbers","Text and numbers (2)","Boolean","Expand cell ref","criteria","criteria (2)","Excel table","SUM VBA","First picture","First picture (2)","First picture (3)","Abs values","threshold","above zero","limit sum","visible cells","filtered column","entire column","row","across sheets","across sheets1","across sheets2","across sheets3","by color","ignore errors"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Cell range","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,"Website: ","Get Digital Help"]
[null,5,null,"Webpage:","How to use the SUM function"]
[null,3]
[null,6]
[null,4]
[null,2]
["Sum:",{"$f":"SUM(B3:B7)","v":20}]

{"sheet":"Array","index":1,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,null,null,null,null,"Website: ","Get Digital Help"]
[null,5,null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,3]
[null,6]
[null,4]
[null,2]
["Sum:",{"$f":"SUM({5;3;6;4;2})","v":20}]

{"sheet":"Cell ranges","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Values1",null,"Values2",null,null,null,"Website: ","Get Digital Help"]
[null,5,null,1,null,null,null,"Webpage:","How to use the SUM function"]
[null,3,null,3]
[null,6,null,2]
[null,4,null,4]
[null,2,null,2]
[]
[]
["Sum:",{"$f":"SUM(B3:B7,D3:D7)","v":32}]

{"sheet":"Text and numbers","index":3,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,null,null,null,null,"Website: ","Get Digital Help"]
[null,5,null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,"AA"]
[null,6]
[null,4]
[null,2]
["Sum:",{"$f":"SUM(B3:B7)","v":17}]

{"sheet":"Text and numbers (2)","index":4,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,null,null,null,null,"Website: ","Get Digital Help"]
[null,"5",null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,"3"]
[null,"6"]
[null,4]
[null,"2"]
["Sum:",{"$f":"SUM(B3:B7)","v":4}]

{"sheet":"Boolean","index":5,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,null,null,null,null,null,"Website: ","Get Digital Help"]
[null,true,null,null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,false]
[null,true]
[null,false]
[null,false]
["Sum:",{"$f":"SUM(B3:B7*1)","v":2}]

{"sheet":"Expand cell ref","index":6,"n_rows":10,"n_cols":11,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Numbers","SUM",null,null,null,null,null,null,"Website: ","Get Digital Help"]
[null,2,{"$f":"SUM($B$3:B3)","v":2},null,null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,1,{"$f":"SUM($B$3:B4)","v":3}]
[null,10,{"$f":"SUM($B$3:B5)","v":13}]
[null,6,{"$f":"SUM($B$3:B6)","v":19}]
[null,8,{"$f":"SUM($B$3:B7)","v":27}]
[null,2,{"$f":"SUM($B$3:B8)","v":29}]
[null,1,{"$f":"SUM($B$3:B9)","v":30}]
[null,2,{"$f":"SUM($B$3:B10)","v":32}]

{"sheet":"criteria","index":7,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Numbers",null,"Item:","B",null,null,null,null,null,"Website: ","Get Digital Help"]
[null,"A",2,null,"Sum:",{"$f":"SUM((B3:B10=F2)*C3:C10)","v":19},null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,"B",1]
[null,"B",10]
[null,"A",6]
[null,"B",8]
[null,"A",2]
[null,"A",1]
[null,"A",2]

{"sheet":"criteria (2)","index":8,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Category","Numbers",null,"Item:","B",null,null,null,null,"Website: ","Get Digital Help"]
[null,"A","Small",2,null,"Category","Large",null,null,null,null,"Webpage:","How to use the SUM function"]
[null,"B","Large",1,null,"Sum:",{"$f":"SUM((B3:B10=G2)*(C3:C10=G3)*D3:D10)","v":9}]
[null,"B","Small",10]
[null,"A","Large",6]
[null,"B","Large",8]
[null,"A","Large",2]
[null,"A","Large",1]
[null,"A","Small",2]

{"sheet":"Excel table","index":9,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Region","Amount",null,null,null,null,null,null,null,null,"Website: ","Get Digital Help"]
[null,"North",14,null,null,null,null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,"South",60]
[null,"North",52]
[null,"North",35]
[null,"South",33]
[null,"North",74]
[null,"South",64]
[null,"Total",{"$f":"SUBTOTAL(109,Table1[Amount])","v":175}]

{"sheet":"SUM VBA","index":10,"n_rows":7,"n_cols":13,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,null,null,null,null,null,null,null,null,"Website: ","Get Digital Help"]
[null,5,null,null,null,null,null,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,3]
[null,6]
[null,4]
[null,2]

{"sheet":"First picture","index":11,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Amount",null,null,"Website: ","Get Digital Help"]
[null,null,5,null,null,"Webpage:","How to use the SUM function"]
[null,null,3]
[null,null,6]
[null,null,4]
[null,null,2]
[]
[null,"Sum:",{"$f":"SUM(C3:C7)","v":20}]

{"sheet":"First picture (2)","index":12,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Quarter","Apples","Oranges","Pears","Bananas",null,null,null,null,"Website: ","Get Digital Help"]
[null,"2020-Q4",5,20,9,16,{"$f":"SUM(C3:F3)","v":50},null,null,null,"Webpage:","How to use the SUM function"]
[null,"2020-Q3",3,12,19,7,{"$f":"SUM(C4:F4)","v":41}]
[null,"2020-Q2",6,4,6,9,{"$f":"SUM(C5:F5)","v":25}]
[null,"2020-Q1",4,19,16,6,{"$f":"SUM(C6:F6)","v":45}]
[null,null,{"$f":"SUM(C3:C6)","v":18},{"$f":"SUM(D3:D6)","v":55},{"$f":"SUM(E3:E6)","v":50},{"$f":"SUM(F3:F6)","v":38},{"$f":"SUM(C7:F7)","v":161}]

{"sheet":"First picture (3)","index":13,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Amount",null,null,null,"Website: ","Get Digital Help"]
[null,null,5,null,null,null,"Webpage:","How to use the SUM function"]
[null,null,3]
[null,null,6]
[null,null,4]
[null,null,2]

{"sheet":"Abs values","index":14,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Amount",null,null,null,"Website: ","Get Digital Help"]
[null,null,5,null,null,null,"Webpage:","How to use the SUM function"]
[null,null,-3]
[null,null,6]
[null,null,-4]
[null,null,2]
[null,null,{"$f":"SUM(ABS(C3:C7))","v":20}]

{"sheet":"threshold","index":15,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,"Above:",5,null,null,"Website: ","Get Digital Help"]
[null,3,null,"Sum:",{"$f":"SUM(IF(B3:B7>E2,B3:B7,))","v":15},null,null,"Webpage:","How to use the SUM function"]
[null,9]
[null,2,null,"Below:",5]
[null,4,null,"Sum:",{"$f":"SUM(IF(B3:B7<E5,B3:B7,))","v":9}]
[null,6]

{"sheet":"above zero","index":16,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,"Sum (above zero):",{"$f":"SUM(IF(B3:B7>0,B3:B7,))","v":8},null,null,null,"Website: ","Get Digital Help"]
[null,1,null,"Sum (below zero):",{"$f":"SUM(IF(B3:B7<0,B3:B7,))","v":-5},null,null,null,"Webpage:","How to use the SUM function"]
[null,-2]
[null,3]
[null,4]
[null,-3]

{"sheet":"limit sum","index":17,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,"Limit (max):",20,null,null,"Website: ","Get Digital Help"]
[null,5,null,"Sum:",{"$f":"MIN(E2,SUM(B3:B7))","v":20},null,null,"Webpage:","How to use the SUM function"]
[null,6]
[null,6,null,"Limit (min):",25]
[null,7,null,"Sum:",{"$f":"MAX(E5,SUM(B3:B7))","v":26}]
[null,2]

{"sheet":"visible cells","index":18,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,null,null,null,"Website: ","Get Digital Help"]
[null,5,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,6]
[null,6]
[null,7]
[null,2]
[]
[null,"Sum:",{"$f":"SUM(B3:B7)","v":26}]
[null,"Subtotal:",{"$f":"SUBTOTAL(109,B3:B7)","v":26}]

{"sheet":"filtered column","index":19,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Amount",null,null,"Website: ","Get Digital Help"]
[null,"A",5,null,null,"Webpage:","How to use the SUM function"]
[null,"B",6]
[null,"A",6]
[null,"B",7]
[null,"A",2]
[]
[null,"Sum:",{"$f":"SUM(C3:C7)","v":26}]
[null,"Subtotal:",{"$f":"SUBTOTAL(109,C3:C7)","v":13}]

{"sheet":"entire column","index":20,"n_rows":102,"n_cols":8,"rows_kept":102,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Amount",null,"Sum entire column:",{"$f":"SUM(B:B)","v":9492},null,"Website: ","Get Digital Help"]
[null,125,null,null,null,null,"Webpage:","How to use the SUM function"]
[null,22]
[null,133]
[null,40]
[null,57]
[null,134]
[null,81]
[null,146]
[null,120]
[null,23]
[null,79]
[null,66]
[null,18]
[null,131]
[null,20]
[null,134]
[null,168]
[null,85]
[null,61]
[null,142]
[null,116]
[null,1]
[null,143]
[null,178]
[null,65]
[null,30]
[null,4]
[null,109]
[null,57]
[null,15]
[null,78]
[null,39]
[null,153]
[null,56]
[null,107]
[null,35]
[null,72]
[null,120]
[null,65]
[null,128]
[null,148]
[null,12]
[null,107]
[null,200]
[null,163]
[null,131]
[null,97]
[null,187]
[null,152]
[null,143]
[null,172]
[null,24]
[null,140]
[null,61]
[null,49]
[null,4]
[null,50]
[null,16]
[null,159]
[null,115]
[null,144]
[null,79]
[null,33]
[null,142]
[null,36]
[null,150]
[null,110]
[null,155]
[null,44]
[null,92]
[null,37]
[null,159]
[null,190]
[null,113]
[null,137]
[null,87]
[null,128]
[null,153]
[null,10]
[null,69]
[null,56]
[null,118]
[null,7]
[null,76]
[null,87]
[null,127]
[null,109]
[null,174]
[null,6]
[null,45]
[null,102]
[null,96]
[null,186]
[null,159]
[null,49]
[null,57]
[null,36]
[null,85]
[null,173]
[null,190]

{"sheet":"row","index":21,"n_rows":14,"n_cols":101,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,125,22,133,40,57,134,81,146,120,23,79,66,18,131,20,134,168,85,61,142,116,1,143,178,65,30,4,109,57,15,78,39,153,56,107,35,72,120,65,128,148,12,107,200,163,131,97,187,152,143,172,24,140,61,49,4,50,16,159,115,144,79,33,142,36,150,110,155,44,92,37,159,190,113,137,87,128,153,10,69,56,118,7,76,87,127,109,174,6,45,102,96,186,159,49,57,36,85,173,190]
[]
[null,"Sum entire row:",{"$f":"SUM(2:2)","v":9492}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Website: ",null,null,"Get Digital Help"]
[null,null,null,null,null,"Webpage:",null,null,"How to use the SUM function"]

{"sheet":"across sheets","index":22,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Sum",null,"Website: ","Get Digital Help"]
[null,"A",null,null,"Webpage:","How to use the SUM function"]
[null,"B",{"$f":"SUM('across sheets1:across sheets3'!C4)","v":11}]

{"sheet":"across sheets1","index":23,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Sum"]
[null,"A",2]
[null,"B",3]

{"sheet":"across sheets2","index":24,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Qty"]
[null,"A",5]
[null,"B",6]

{"sheet":"across sheets3","index":25,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Qty"]
[null,"A",1]
[null,"B",2]

{"sheet":"by color","index":26,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Numbers",null,"Item:","B",null,null,"Website: ","Get Digital Help"]
[null,"A",2,null,"Sum:",{"$f":"SUM((B3:B10=F2)*C3:C10)","v":19},null,null,"Webpage:","How to use the SUM function"]
[null,"B",1]
[null,"B",10]
[null,"A",6]
[null,"B",8]
[null,"A",2]
[null,"A",1]
[null,"A",2]

{"sheet":"ignore errors","index":27,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Item","Qty",null,null,null,"Website: ","Get Digital Help"]
[null,"A",5,null,null,null,"Webpage:","How to use the SUM function"]
[null,"B",{"$f":"1/0","v":{"$error":"#DIV/0!"}}]
[null,"C",6]
[null,"A",{"$f":"BSf","v":{"$error":"#NAME?"}}]
[null,"C",2]
[]
[null,"Sum:",{"$f":"SUM(IFERROR(C3:C7,0))","v":13}]