How to calculate the crosssum in the table?

Question

Google Sheets

The task is to calculate the quessum like here , only in Google tables.
For example, they wrote MARIA in one cell, the sum 22 was displayed in the other.

Answer 1

For an "incomplete" or "unfolded" sum, the following is true:

=SUMPRODUCT(--MID(Цифровое_представление;ROW(INDIRECT("1:"&LEN(Цифровое_представление)));1))

Цифровое_представлениеis a cell in which the text is represented as a sequence of numbers.
For the full sum, like this formula:

=IFERROR(
  MOD(SUMPRODUCT(--MID(Цифровое_представление;ROW(INDIRECT("1:"&LEN(Цифровое_представление)));1));9)
    +(MOD(SUMPRODUCT(--MID(Цифровое_представление;ROW(INDIRECT("1:"&LEN(Цифровое_представление)));1));9)=0)*9;
  -1
)

It is cyclical, counts SUMPRODUCTand adds up all the numbers.

Wrote a small application on Spreadsheets that repeats the functionality of the site Spreadsheet

itself https://docs.google.com/spreadsheets/d/19bQjuZpRaE...
Example of use