Sum of even digits

I have a challenge. I am pretty good in Excel myself but this one is a bit complex.

I'd like to have the sum of even digit positions of a number. Example:
1234567890
then I'd like to get the following results:
9+7+5+3+1=25

So I was thinking to apply a digit mask (101010101010) first but it seems Excel doesn't have such an option except binary.

If this would be possible then I can take the sum of all digits of the number.

Of course a "nasty" solution would be to split the number to digits in rows and then in a new column detect if the row is even, if so then copy the value and then sum the column. But that takes a lot of calculations and I need to do this for tons of large numbers.

Last but not least: I'd like to do this via a formula and not VBA.

So I am now asking the Excel masters & guru's

Could you upload a sanitized sample of your data, with raw data, and show your desired results?
Pete

Try this:

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&INT(LEN(A1)/2)))*2-ISEVEN(LEN(A1)),1))

AliGW, no I am not. I guess you read odd values. I wrote odd digit positions.

PeteABC123, that would make it overly complicated. What matters is this:
I need to have a sum of all the even digit positions in a number.
So as in my example:
1234567890
1010101010
----------
1030507090

Sum of all digits:
1+0+3+0+5+0+7+0+9=25


Or:
6789
1010
----
6080

Sum of all digits:
6+0+8+0=14

Phuocam: you are AWESOME!!!

You can use this array* formula in B2, assuming your string of numbers is in A2:

=SUM(IF((MOD(ROW($1:$10),2)=1),--(MID(A2,ROW($1:$10),1))))

*Note that an array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual < Enter >

Hope this helps.

Pete

AliGW & SjonR, it seems I am wrong here about digit positions. The first digit seems to be called digit 0 by you guys as in programming languages. Sorry for the confusion. I just thought the first digit position of a number would be called 1. And the second digit would be position 2.
Nevertheless the problem has been solved. Thanks a lot for the great help!

I can see the OP's logic - the least significant digit (0) is the first digit position, the next least significant (9) is in position 2, and so on. He is just numbering the digits from the other end.

In his other example (Post #5) of 6789, the 9 is in digit position 1, the 8 in 2, and so on.

Hope this helps.

Pete

Originally Posted by Glenn Kennedy

... and would like to understand the logic behind starting from the right....

Glenn,

consider building up a binary number by adding 1 each time - you would have this:

a 0
b 1

this is bit 1

c 10
d 11

we now have bits 2 and 1

e 100

and move into having bits 3, 2 and 1, and so on.

Bit 1 is always the least significant bit, and the most significant bit has the largest bit position. Because we are used to reading left to right, this numbering seems odd, but it is logically consistent.

Hope this helps.

Pete

Incidentally, you can amend my formula to this (changes in red):

=SUM(IF((MOD(ROW($1:$10),2)=1),IFERROR(--(MID(A2,ROW($1:$10),1)),0)))

to take account of numbers with fewer than 10 digits. Commit with CSE, as previously described.

(the OP doesn't seem to be listening anymore).

Hope this helps.

Pete