Count Data in Range increment by 5 columns

[bdtran]

Hi All,

I encountered a situation where I need to create a formula get the result as in the Row5 by counting how many #5 in row3 range increment by 5 columns for the next result.

example below:

B5=COUNTIF($B3:F3,"5")
C5=COUNTIF($B3:K3,"5")
D5=COUNTIF($B3:P3,"5")
E5=COUNTIF($B3:U3,"5")

Is there a way to create a formula in B5 and drag along get the result automatically.

Thanks,
*BDT

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
2
3	Data	5	6	5	6	5	4	5	5	5	2	5	5	6	6	5	3	4	5	5	5
4
5	Count how many "5" every 5 columns increment	3	6	9	12

<tbody>
</tbody>

 

[DRSteele]

Try this in B5 and copy rightwards.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIFS(OFFSET($B$3,,,,COLUMNS($B$5:B5)*5),5)[/FONT]