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
{=SUM(VALUE(MID(ABS(Cell_Address),ROW(INDIRECT("1:"&LEN(ABS(Cell_Address)))),1)))}