Inserting "x" into cell which then converts into ascending numbers.

[jb1konobe]

Hi my problem is that I would like to be able to insert an X on a touch pad device that would covert into a number starting from 1 when inserted and ascending, so insert X a second time and it would then convert number to 2...etc. If that is achievable then is it possible that it would add up the totals in a in a "totals cell" at bottom of page. So 'CELL' A1 (which had 2 x's)=2,'CELL' A2 (which had 3 x's)=3, 'Total sum' Cell A3=5
I hope I have explained my problem clearly enough. Thanks for your help in advance.

[martindwilson]

xx in a1
xxx in a2
a3
=len(a1)+len(a2)
or for more
=SUMPRODUCT(LEN($A$1:$A$200))

[jb1konobe]

Thanks martindwilson for your quick reply.
I probably haven't expressed myself very well because you answered my question as I asked it. So I will try and explain it better this time.
What I would like to achieve (but the more i think about it is probably unrealistic)is when I insert an "X" in a cell it will give me value, then I would like to override the "X" with another "X" and get the next ascending number....For example: Cell A1 insert x = 1, then insert another x and override previous x in cell A1=2. So at any one time there is only 1 "x" in a cell. This would then continue for each cell in the range and then calculate a total numeric value in a designated cell below.
Hope that make sense. Thanks again.

[FDibbins]

Hi and welcome to the forum

What you want (enter a data in a cell, then enter more data in that same cell and have it accumulate) is not possible with regular formulas. A cell can either contain data OR a formula, it cant contain both.

However, this can be done with VBA, so Im sure some-one will be able to help you. I will move this thread to the VBA forum to get better exposure

[jb1konobe]

Thanks FDibbins for the warm welcome and all of your assistance, its much appreciated.

[FDibbins]

Happy to help