Forum Discussion
Count cell number
I want to sum the cell number count by using SUM / VALUE / MID / ROW / INDIRECT / ADDRESS / LEN
Please help
As variant that could be array formula
=SUM(IFERROR(VALUE(MID(A2,ROW($1:$100),1)),0))
and attached
As variant that could be array formula
=SUM(IFERROR(VALUE(MID(A2,ROW($1:$100),1)),0))
and attached
