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
2 answers
April 19th 20 at 12:26
For "incomplete" or "unfolded" amount true:


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

For the full amount like this formula:


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


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


The table itself

Alexander Ivanov 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:
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