Sum all the individual digits of a number

{=SUM(VALUE(MID(ABS(Cell_Address),ROW(INDIRECT("1:"&LEN(ABS(Cell_Address)))),1)))}


© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top