Count every Nth collum

[andes7]

Hi, I have a formula that I'm struggling with.

I have 4 columns of data that repeat throughout a spreadsheet.

Column H, I, J and K that contain the following data types, Text, Number, Number and Currency. These 4 columns repeat a number of times, L, M, N, O, and P, Q, R, S, and T, U, V, W an so on.

In column D, E, F and G I wish to sum the columns.

In Column D, I wish to count all the instances of a particular instance of text (If the cell has a "x" in it)
In column E, I wish to sum all of the columns values (I, M, Q U and so on..)
In column F, I wish to sum all of the columns values (J, N, R, V and so on..)
In column G, I wish to sum all of the columns values (K, O, S, W and so on..)

Can anyone assist? This will then repeat for every ROW of values .

 

[Aladin Akyurek]

If you don't have headers that can guide the processing, try something lke:

=SUMPRODUCT(--(MOD(COLUMN(range)-COLUMN(INDEX(range,1,1)),4)=0),--(range="x"))

which allows you to count the x's at every 4th column.