Formula

Shailesh1982 

As a comment, formula suggested by Detlef_Lewin is more flexible and could count any reasonable number of numbers within cell.

To expand PeterBartholomew1 formula as variant

=LET(input, A1, sep, ",",
   seps,  LEN(input)-LEN(SUBSTITUTE(input,sep,"")),
   k,     SEQUENCE(seps+1),
   start, IFERROR( FIND("|",SUBSTITUTE(input, sep,"|",k-1))+1,1),
   end,   IFERROR( FIND("|",SUBSTITUTE(input, sep,"|",k)),LEN(input)+1),
   SUM(--TRIM(MID(input, start, end-start)))
)

Shailesh1982 

Here is the simplest formula for the checksu.

For multi-digit numbers you have to expand the formula accordingly.

Example 1: "=MID(A1,1,1)+MID(A1,2,1)+MID(A1,3,1)", use without goosefoot.

Example 2: "=SUMPRODUCT(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)*1) ", use without goosefoot.

Example 3: "{=SUM(1*MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))}" , use without goosefoot.

*3 Array formulas must always be confirmed with the key combination "CTRL + SHIFT + ENTER"

The file with the examples is included.

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

Shailesh1982 

Is that like this?

Shailesh1982 

IF you are using Excel 365 and IF your cells/range is called 'input' and IF each cell comprises two numbers separated by a comma, then

= LET(sep, ",",
  p,      FIND(sep, input),
  first,  MID(input, 1, p-1),
  second, MID(input, p+1, 15),
  first+second )

otherwise you need something different!

Shailesh1982 

You can find precise details on how to quickly and precisely come up with a proposed solution in the link below

Welcome to your Excel discussion space!

Please include the following info to help others answer your question

Thank you for your understanding and patience

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)