How to determine the number?
Hi Eric
try
=SUMPRODUCT(--MID(A1,ROW(INDIRECT("$1:$"&LEN(A1))),1))
--
Regards
Roger Govier
"Eric" wrote in message
...
Does anyone have any suggestions on how to determine the number?
For example, 2584 in cell A1, then it should return 2+5+8+4=19 in cell B1.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric
|