# 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
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.

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

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: