I have seen the use of "--" in a few responses here and in other groups
but fail to understand what the 2 '--'s do or why they are necessary. I
see that 1 - returns a negative, therefore 2 -'s return a positive, but
why does + or nothing, that is "(MID(....") return 0?
Can you explain?
Thanks

Biff wrote:
eg 1347 --- 25


Shouldn't that be 15?


A1 = 1347

=SUMPRODUCT(--MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))

Returns 15

Biff

"Biff" wrote in message
...

eg 1347 --- 25

Shouldn't that be 15?

Biff


"willie Loh" <willie wrote in message
...

i am trying to sum a number into single number?

eg 1347 --- 25

please help