Thank you!

If that A1 cell data suddenly becomes just 1,4,6 will the formula you mentioned handle it?
Is there not a general formla that sums.

By the way, what is the SUM formula if I have 1,4,6 ?

Thanks
Dan