How to calculate quersumme in the table?

The problem is that were counting quersumme like here , only in Google spreadsheets.
Wrote for example in a single cell in MARY, the other shows the sum of 22.
April 19th 20 at 12:24

Related questions

More answers about "How to calculate quersumme in the table?"
2 answers
April 19th 20 at 12:26
Solution
For "incomplete" or "unfolded" amount true:

=SUMPRODUCT(--MID(Zimoveiskaya;ROW(INDIRECT("1:"&LEN(Zimoveiskaya)));1))


Zimoveiskaya is a cell in which the text is presented in a sequence of numbers

For the full amount like this formula:

=IFERROR(
MOD(SUMPRODUCT(--MID(Zimoveiskaya;ROW(INDIRECT("1:"&LEN(Zimoveiskaya)));1));9)
+(MOD(SUMPRODUCT(--MID(Zimoveiskaya;ROW(INDIRECT("1:"&LEN(Zimoveiskaya)));1));9)=0)*9;
-1
)


It is cyclical, due to the SUMPRODUCT lists and adds up all the numbers.

5e995b76a3305815289730.png

Wrote a small application on Tables that replicates the functionality of the site

5e995b90901c6146199371.gif

The table itself https://docs.google.com/spreadsheets/d/19bQjuZpRaE...

Sincerely,
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Alexander Ivanov
contributor.pw Google Apps & APIs. Scripts, Tables,...
April 19th 20 at 12:28
Alexander, don't understand how this gorgeous and brilliant solution to tie to my table.
I want in one cell to write the name in next cell I need to release quersumme 1, in the following quersumme 2, in the following quersumme 3. Will be text only.
an example of how it should look:
https://docs.google.com/spreadsheets/d/1vqKnsN_8qQ...
I don't mind if you want to create extra sheet and there is a full kitchen place, it is important that the "face" was about as in the table on the link. How to implement it?

Find more questions by tags Google Sheets