{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Formula","VBA Code"],"not_rendered":{"charts":0,"images":1,"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":"Formula","index":0,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,"Sum Digits of a Number",null,null,null,"http://www.goodly.co.in/how-to-sum-digits-of-a-number/"]
[null,"Some Random Nos","Totalling Once","Totalling Twice","Totalling Thrice"]
[null,9899830308,{"$f":"SUM(VALUE(MID(B3,ROW(INDIRECT(\"1:\"&LEN(B3))),1)))","v":57},{"$f":"SUM(VALUE(MID(C3,ROW(INDIRECT(\"1:\"&LEN(C3))),1)))","v":12},{"$f":"SUM(VALUE(MID(D3,ROW(INDIRECT(\"1:\"&LEN(D3))),1)))","v":3}]
[null,9984396417,{"$f":"SUM(VALUE(MID(B4,ROW(INDIRECT(\"1:\"&LEN(B4))),1)))","v":60},{"$f":"SUM(VALUE(MID(C4,ROW(INDIRECT(\"1:\"&LEN(C4))),1)))","v":6},{"$f":"SUM(VALUE(MID(D4,ROW(INDIRECT(\"1:\"&LEN(D4))),1)))","v":6}]
[null,9624229853,{"$f":"SUM(VALUE(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)))","v":50},{"$f":"SUM(VALUE(MID(C5,ROW(INDIRECT(\"1:\"&LEN(C5))),1)))","v":5},{"$f":"SUM(VALUE(MID(D5,ROW(INDIRECT(\"1:\"&LEN(D5))),1)))","v":5}]
[null,9947683738,{"$f":"SUM(VALUE(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)))","v":64},{"$f":"SUM(VALUE(MID(C6,ROW(INDIRECT(\"1:\"&LEN(C6))),1)))","v":10},{"$f":"SUM(VALUE(MID(D6,ROW(INDIRECT(\"1:\"&LEN(D6))),1)))","v":1}]
[null,9938900079,{"$f":"SUM(VALUE(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)))","v":54},{"$f":"SUM(VALUE(MID(C7,ROW(INDIRECT(\"1:\"&LEN(C7))),1)))","v":9},{"$f":"SUM(VALUE(MID(D7,ROW(INDIRECT(\"1:\"&LEN(D7))),1)))","v":9}]
[null,9787299867,{"$f":"SUM(VALUE(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)))","v":72},{"$f":"SUM(VALUE(MID(C8,ROW(INDIRECT(\"1:\"&LEN(C8))),1)))","v":9},{"$f":"SUM(VALUE(MID(D8,ROW(INDIRECT(\"1:\"&LEN(D8))),1)))","v":9}]
[null,9905197732,{"$f":"SUM(VALUE(MID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1)))","v":52},{"$f":"SUM(VALUE(MID(C9,ROW(INDIRECT(\"1:\"&LEN(C9))),1)))","v":7},{"$f":"SUM(VALUE(MID(D9,ROW(INDIRECT(\"1:\"&LEN(D9))),1)))","v":7}]
[null,9627224675,{"$f":"SUM(VALUE(MID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1)))","v":50},{"$f":"SUM(VALUE(MID(C10,ROW(INDIRECT(\"1:\"&LEN(C10))),1)))","v":5},{"$f":"SUM(VALUE(MID(D10,ROW(INDIRECT(\"1:\"&LEN(D10))),1)))","v":5}]
[null,9908085266,{"$f":"SUM(VALUE(MID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1)))","v":53},{"$f":"SUM(VALUE(MID(C11,ROW(INDIRECT(\"1:\"&LEN(C11))),1)))","v":8},{"$f":"SUM(VALUE(MID(D11,ROW(INDIRECT(\"1:\"&LEN(D11))),1)))","v":8}]
[]
[null,"Confirm the formula by pressing CTRL + SHIFT + ENTER"]

{"sheet":"VBA Code","index":1,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,9899830308]
[null,9984396417,null,null,null,null,null,null,null,null,null,null,"http://www.goodly.co.in/how-to-sum-digits-of-a-number/"]
[null,9624229853]
[null,9947683738]
[null,9938900079]
[null,9787299867]
[null,9905197732]
[null,9627224675]
[null,9908085266]