Count All values in every 3rd column

[ZivilynBane64]

Hello! I'm trying to figure out the formula that would count all specific values in every third column.
Basically every 3rd column, I have a list of names. This goes on for hundreds of columns. Think of these as Win/Loss columns, so I can't just count all columns. It's every 3rd column. I need to be able to count how many times one persons name appears in the win columns in total, and how many times their name appears in the loss column in total. Data starts at K5:K. So I need to count the number of times the name appears in K5:K + N5:N + Q5:Q + T5:T ......
Please help

 

[ZivilynBane64]

This might be more clear context: I'm essentially trying to avoid having to type this formula because the dataset is very large (it goes all the way to ZX currently and will get bigger):

=COUNTIF(K5:K,D5)+COUNTIF(N5:N,D5)+COUNTIF(Q5:Q,D5)......

Need it to count all instances of whatever is in D5 for every third column starting with K.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Guessing a bit about what your data is like but see if something like this might help.

23 12 10.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Name	Wins	Losses				Round 1	Win	Loss	Round 2	Win	Loss	Round 3	Win	Loss	Round 4	Win	Loss
2	Name 1	2	1					Name 1	Name 10		Name 2	Name 18		Name 12	Name 7		Name 15	Name 21
3	Name 2	3	1					Name 3	Name 19		Name 23	Name 19		Name 17	Name 23		Name 24	Name 8
4	Name 3	2	2					Name 14	Name 16		Name 25	Name 3		Name 22	Name 25		Name 6	Name 2
5	Name 4	2	1					Name 6	Name 13		Name 17	Name 25		Name 24	Name 24		Name 6	Name 23
6	Name 5	1	3					Name 3	Name 14		Name 6	Name 6		Name 9	Name 4		Name 16	Name 16
7	Name 6	5	2					Name 4	Name 23		Name 15	Name 3		Name 15	Name 19		Name 8	Name 17
8	Name 7	0	1					Name 16	Name 25		Name 1	Name 5		Name 2	Name 22		Name 14	Name 1
9	Name 8	1	1					Name 2	Name 6		Name 14	Name 22		Name 12	Name 23		Name 21	Name 16
10	Name 9	2	0					Name 9	Name 10		Name 4	Name 5		Name 11	Name 21		Name 5	Name 23
11	Name 10	0	3					Name 6	Name 22		Name 19	Name 10		Name 24	Name 23		Name 23	Name 5
12	Name 11	1	0
13	Name 12	2	0
14	Name 13	0	1
15	Name 14	3	1
16	Name 15	3	0
17	Name 16	2	3
18	Name 17	2	1
19	Name 18	0	1
20	Name 19	1	3
21	Name 20	0	0
22	Name 21	1	2
23	Name 22	1	3
24	Name 23	2	6
25	Name 24	3	1
26	Name 25	1	3
Count

Cell Formulas
Range	Formula
E2:E26	E2	=SUMPRODUCT((K$1:U$1="Win")*(K$2:U$11=D2))
F2:F26	F2	=SUMPRODUCT((K$1:U$1="Loss")*(K$2:U$11=D2))

 

[ZivilynBane64]

Thank you Peter that worked perfectly! I didn't think about labelling the top of the rows win/loss to ensure it was counting from the correct columns. You are awesome sir!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

I had assumed headings something like I used would have already been there otherwise it could be a tricky worksheet for anybody reading it.