A IF functions Condition: x>1 - how to increase by 1 next time: x>(1 + 1) ... and next time x>(1+1+1)

[T-buch1]

The Condition-placeholder of the function is thus: IF(A1>1; ......)
In the next row I want it to be:(A1>(1 + 1)
next time: (A1>(1+1+1) and so on

I try to find a way to avoid any “help-cells” - I need a kind of a counter

[karolus]

Be aware off…if you insert new rows manually … it changes the condition in any Cell below!!!

[T-buch1]

Yes of course I see that. We can do anything else to count how many times we copy?

[karolus]

with initial Formula:

=IF(A$1>ROWS(A$1:A1); … ; … )

Now you may insert Rows (above or below ) (but not between) the Cellrange with Formulas without changing the Conditions

[karolus]

Hallo

=IF(A1>ROW(A1) ; … ; … )

and pull down.

[Villeroy]

counter.odb (23.4 KB)

Open the database document and the form therein.
Enter a number into the upper box or use the up/down arrow keys.
[OK] or Enter key stores the number.
The [Sum] button shows the current sum.
The database document contains a printable report showing all entered numbers with time-stamp.

[T-buch1]

Java bla bla bla erors again again, sorry

[Villeroy]

OK, without Java:
Counter_Firebird.odb (26.7 KB)