Formula to increment a cell value by one

[Seniornetman]

I am trying to create an automatic increment. the Formula I tried is =IF(OR(L2="P",L2="T"),G2+1,G2) I had it working but it was requiring me to have the values in 2 places to function and the source remained the same so it would not increment but once. If someone could give me the correct formula to increment the value in G2 by one when the P or T is entered in L2 I would really appreciate it. Thank You

 

[Asbestos_Jen]

Maybe I don't quite understand what you mean, but your formula works for me.

Book1
	G	H				L	M
1							G2 or G2+1
2	1					P	2
3	2					T	3
4	1					a	1
5	2					b	2
6	2					c	2
7	1					d	1
8	2					e	2
9	1					f	1
10	2					g	2
11	2					h	2
12	1					i	1
13	2					P	3
14	1					T	2
15	2					f	2
16	2					T	3
17	1					h	1
18	2					r	2
19	1					P	2
Sheet1

Cell Formulas
Range	Formula
M2:M19	M2	=IF(OR(L2="P",L2="T"),G2+1,G2)

 

[Seniornetman]

The number is in G2 already and I need it to increment in that Cell. I can put it in another cell and it will increment but then it won't do it again because the source cell does not increment. For some reason (probably because I am not that familiar with this, 25 years working on servers and networks and just making applications work but not really using them) When I put it in G2 it won't take a number. If I put it in L2 it doesn't work. I did get it to work but only when I put it in another cell that had the starting number in it and it worked but then I would have to manually change the other cell for it to increment again. This will be incrementing almost daily.

 

[Seniornetman]

I am trying to create an automatic increment. the Formula I tried is =IF(OR(L2="P",L2="T"),G2+1,G2) I had it working but it was requiring me to have the values in 2 places to function and the source remained the same so it would not increment but once. If someone could give me the correct formula to increment the value in G2 by one when the P or T is entered in L2 I would really appreciate it. Thank You

Maybe This will help G2 is the Day and L2 is the date. The other cells aren't involved.

Day	Sentence	ER?	D or M	Points	5/31/2024​
35​	45​	Yes	M	450​
27​	30​	Yes	M	300​

 

[Cubist]

Is this what you mean?

Book1
	G					L
1
2	1					P
3	2					T
4	2					a
5	2					b
6	2					c
7	2					d
8	2					e
9	2					f
10	2					g
11	2					h
12	2					i
13	3					P
14	4					T
15	4					f
16	5					T
17	5					h
18	5					r
19	6					P
Sheet3

Cell Formulas
Range	Formula
G2:G19	G2	=SCAN(0,L2:L19,LAMBDA(a,b,OR(b="P",b="T")+a))
Dynamic array formulas.

 

[Asbestos_Jen]

The number is in G2 already and I need it to increment in that Cell.

That sounds like a circular reference. I think you need VBA to accomplish this. Unfortunately, I can't help you with that, but lots of wonderful people here are versed in it.
Edit to add: Where is the source and how does it relate to the P or T criteria in L2?

 

[Scott Huish]

You asked me this same question in this post:

How to increment a number in one cell based on a letter in another

I want to increment a number in one cell based on the letter P, T or A in another cell. How can I go about this?

www.mrexcel.com