Autonumber Payments

[Robby19]

Good day,

Tried searching for this, but was unable to come up with anything that solved my problem. I am trying to write a formula to autonumber the payments received from each customer.

[TABLE="width: 500"]
<TBODY>[TR]
[TD]ID
[/TD]
[TD]Payment #
[/TD]
[/TR]
[TR]
[TD]1001
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]1001
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]2001
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]3001
[/TD]
[TD]1
[/TD]
[/TR]
[TR]
[TD]1001
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]2001
[/TD]
[TD]2
[/TD]
[/TR]
</TBODY>[/TABLE]

Having trouble coming up with a formula to auto-compute the "Payment #" column.

 

[jtakw]

Hi,

Change/adjust cell reference as needed, formula copied down:

Book1
	H	I
1	ID	Payment #
2	1001	1
3	1001	2
4	2001	1
5	3001	1
6	1001	3
7	2001	2
Sheet520

Cell Formulas
Range	Formula
I2	=COUNTIF(H$2:H2,H2)

 

[majidsiddique]

hi robby19,
i think you want this?
enter E2,
1001
2001
3001

please try.
=SUMIF($B$2:$C$7,E2,$C$2:$C$7)

[TABLE="width: 122"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]ID[/TD]
[TD]Payment Rec[/TD]
[/TR]
[TR]
[TD="align: right"]1001[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]2001[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]3001[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]