Formula that add digits when encounter

[serge]

I'm looking for a formula that will add each time it find the duplicate digits per column.

 

[FormR]

Hi, if I've understood correctly - here is an option to try. Formula in C3 copied down and across.

Excel 2013/2016
	A	B	C	D	E	F
1			0	1	2	3
2
3	3					1
4	1			1
5	0		1
6	0		2
7	3					2
8	3					3
9	1			2
10	0		3
11	1			3
12	3					4
13	2				1
14	0		4
15	1			4
16	3					5
17	3					6
18	2				2
Sheet1

Cell Formulas
Range	Formula
C3	=IF($A3=C$1,COUNTIFS($A$3:$A3,C$1),"")

 

[serge]

woaw, thank you so much FormR, your formula works like a charm, I really appreciate your help.
Serge.