sumifs and count

[Tennisguuy]

I have a spread sheet with values in J13:L212. I want to create a formula that will count the number of times a value appears in rows J13:L13 if the sum of the values in J13:L13 is equal to 4.
I tried the following if(sum(J13:J212)+sum(K13:K212)+sum(L13:L212)=4, and that worked for the sum but having a problem incorporating the count

 

[Eric W]

I'm a little unsure, but maybe:

Book1 (version 1).xlsb
	J	K	L	M	N
13	1	1	2		5
14	2	1	1
15	3	-1	2
16	4	0	0
17	5	-2	1
18	6	4	2
19	7	3	1
20	1	6	2
Sheet11

Cell Formulas
Range	Formula
N13	N13	=SUMPRODUCT(--(MMULT(J13:L212+0,{1;1;1})=4))

 

[Tennisguuy]

You're the man. Thanks bro that worked perfectly. I really appreciate your help.