Count occurrence of 2 value combinations

[ddub25]

[TABLE="width: 113"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]W1-A[/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]2[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]5[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]W1-A[/TD]
[TD]6[/TD]
[TD]1[/TD]
[/TR]
</tbody>[/TABLE]

I am trying to create a formula for the 3rd column. The 3rd column counts the occurrences of the same combinations in the first two columns. For example, in row 4 the formula has recognised that 'W1-A' and '1' have occurred in columns 1 and 2 respectively for the 2nd time and it returns a count of 2 for the 3rd column. In row 5 it returns a '3' as that combination has now occurred 3 times.

Can anyone help with a formula that would be able to make these counts in column 3.

Thanks in advance.

 

[Fluff]

Try

Excel 2013/2016
	A	B	C
19	W1-A	1	1
20	W1-A	2	1
21	W1-A	3	1
22	W1-A	1	2
23	W1-A	1	3
24	W1-A	3	2
25	W1-A	4	1
26	W1-A	5	1
27	W1-A	6	1
Sheet2

Cell Formulas
Range	Formula
C19	=COUNTIFS($A$19:$A19,A19,$B$19:$B19,B19)

 

[ddub25]

Thanks very much Fluff, problem solved. You're a great help

Dan

 

[Fluff]

You're welcome & thanks for the feedback