Count how many times a pattern occur

[vladi305]

Hi Members,

I'm looking to count how many times each pattern occur. I tried using COUNTIFS but not luck. Like this: =COUNTIFS($Q25,"=GP1",$R25,"=GP2",$S25,"=GP3",$T25,"=GP4",$T25,"=GP5")

For example GP1 GP3 and GP4 is a pattern
GP1 GP2 and GP4 is another pattern a so on

Maybe another function or the same countifs but i'm missing something

See the attached pic

 

[JvdV]

Book1
	A	B	C	D	E	F
1	GP1			GP4		1
2		GP2		GP4	GP5	2
3			GP3	GP4	GP5	1
4	GP1		GP3	GP4	GP5	1
5	GP1		GP3		GP5	1
6		GP2	GP3	GP4	GP5	1
7		GP2	GP3	GP4		1
8		GP2		GP4	GP5	2
Sheet9

Cell Formulas
Range	Formula
F1:F8	F1	=COUNTIFS(A:A,A1&"",B:B,B1&"",C:C,C1&"",D:D,D1&"",E:E,E1&"")

 

[vladi305]

Book1
	A	B	C	D	E	F
1	GP1			GP4		1
2		GP2		GP4	GP5	2
3			GP3	GP4	GP5	1
4	GP1		GP3	GP4	GP5	1
5	GP1		GP3		GP5	1
6		GP2	GP3	GP4	GP5	1
7		GP2	GP3	GP4		1
8		GP2		GP4	GP5	2
Sheet9

Cell Formulas
Range	Formula
F1:F8	F1	=COUNTIFS(A:A,A1&"",B:B,B1&"",C:C,C1&"",D:D,D1&"",E:E,E1&"")

Kudos for you! Thank you!