Excel: Count every Nth collum


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 .


This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of January 29, 2018.


For more resources for Microsoft Excel