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.

ID	Payment #
1001	1
1001	2
2001	1
3001	1
1001	3
2001	2

<TBODY>
</TBODY>

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)

ID	Payment Rec
1001	6
2001	3
3001	1

<colgroup><col><col></colgroup><tbody>
</tbody>