Hi,

Not sure is it possible or not but still hope for a way out.

Please find the attachment .xlsm sheet -or- .Jpeg
what i trying to achieve is in the Column M we have a value, When ever user enter Value in 'M14:M1048576'. Previous value enter should not be remove instead of that should add (+) new value next to its previous value.

i.e:
when user enter 1200 in M14 it should add like this =11000+1200 and appears total value in M14 in Formula Bar when cell is selected.

It is possible when ever a user enter a value it appears with + and add the value next to the previous value

sample.jpg

sample Book1.xlsm

looking forward for a solution

Best