COUNT IF FORMULA for Two Column Condition

[Samael2021]

DEAR SIR,
Let me ask you a little bit. I want to increase the count if (A1,B1) value is the same with (A2,B2). Can someone provide a formula for this? Please help me.
Thank you so much!!

A B C
No1 No2 Count
1 1 1
1 1 2
2 3 1
2 0 1
1 1 3

 

[Radoslaw Poprawski]

that explanation is quite bad.

2 solutions cos I'm not sure which 1 ur after exactly

Book1
	A	B	C	D	E
9	A	B	expeted	Count	Count
10	1	1	1	3	1
11	1	1	2	3	2
12	2	3	1	1	1
13	2	0	1	1	1
14	1	1	3	3	3
Sheet1

Cell Formulas
Range	Formula
D10:D14	D10	=COUNTIFS($A$10:$A$14,A10,$B$10:$B$14,B10)
E10:E14	E10	=COUNTIFS($A$10:$A10,A10,$B$10:$B10,B10)

 

[Samael2021]

that explanation is quite bad.

2 solutions cos I'm not sure which 1 ur after exactly

Book1
	A	B	C	D	E
9	A	B	expeted	Count	Count
10	1	1	1	3	1
11	1	1	2	3	2
12	2	3	1	1	1
13	2	0	1	1	1
14	1	1	3	3	3
Sheet1

Cell Formulas
Range	Formula
D10:D14	D10	=COUNTIFS($A$10:$A$14,A10,$B$10:$B$14,B10)
E10:E14	E10	=COUNTIFS($A$10:$A10,A10,$B$10:$B10,B10)

Thank you so much, Sir.

 

[Radoslaw Poprawski]

glad to help.