Sumproduct with an IF statement

[JTL9161]

I have this formula below. I need to add and if statement to it that if the total is less than 4 (<4) then just put an 0 but if 4 or greater (>4) then show the number.

=SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))

Thank You,
James

 

[DanteAmor]

Try this

=IF(SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))<4,0,SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))) <tbody> </tbody>

<tbody>
</tbody>

 

[Scott Huish]

or

=SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))*(SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))>=4)

 

[JTL9161]

Sorry, when there is a 4 or higher it gives a "0".

 

[Scott Huish]

Sorry, I read that wrong. Please see edited formula above.

Excel 2010
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
2									4	4							1	2	3	4
192	4	1	3	4
Sheet1

Cell Formulas
Range	Formula
J2	=IF(SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))<4,0,SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192)))
K2	=SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))*(SUMPRODUCT(COUNTIF(R2:U2,B$192:Q$192))>=4)

 

[JTL9161]

My bad. All the numbers were 4 so they were not GREATER than 4. I changed the end to >=4 and it works.

Thanks